Interested to Buy Any Domain ? << Click Here >> for more details...
how to generate XML out of QUERY?
- 1 Answers
- 5121 Views
- McAfee, I also Faced
- E-Mail Answers
Answer / mahendra raja
select * from [table name] for xml auto (or)
select * from [table name] for xml raw
But if there is any binary field column in table then this
query wont work.
| Is This Answer Correct ? | 9 Yes | 0 No |
List out some of the requirements to set up a sql server failover cluster?
Difference between group by clause and having clause in SQL?
How to write a query with a left outer join in ms sql server?
What is index fragmentation in ms sql server?
How to insert multiple rows with a subquery?
What is the meaning of resultset type_scroll_insensitive?
Explain database normalization?
Can you explain what are commit and rollback in sql?
How to change server name in sql server?
Why use sub query in sql server and list out types of sub queries?
What are locks in sql?
How to create a dml trigger using create trigger statements?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
