Answer Posted / 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 |
Post New Answer View All Answers
What are the database roles? : sql server security
How is sql server used?
Can two tables have the same primary key?
do you know how to configure db2 side of the application? : Sql server database administration
What are the different types of upgrades that can be performed in sql server?
Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
What is the use of partition by in sql server?
What is triggers in ms sql server?
What is a user-defined function in the sql server and what is its advantage?
Is candidate a key?
Are semicolons required at the end of sql statements in sql server 2005?
What is an indexed view?
Explain the usage of floor function in sql server.
What are cascading parameters in ssrs reports?
Write an sql query to sort a table according to the amounts in a row and find the second largest amount.