Interested to Buy Any Domain ? << Click Here >> for more details...
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
I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration
What is a matrix in ssrs?
What are the differences between local and global temporary tables?
How to change server name in sql server?
What is named calculation? : sql server analysis services, ssas
What is a user-defined function in the sql server and what is its advantage?
What is the name of the Database which IBM mainframe uses?
Can you please explain the difference between primary keys and foreign keys?
Difference between Sql server reporting services and Crystal reports?
Can we create clustered index on composite key?
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
What is the difference between lock, block and deadlock? : sql server database administration
Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?
What is set nocount on and what is set nocount off?
What do you understand by the analysis services in sql server?
