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
How would you go about developing a ssrs report?
What is the meaning of resultset type_scroll_insensitive?
When would you use the stored procedures or functions?
What are partitioned views and distributed partitioned views?
Can we add a cpu to sql server?
System requirements for sql server 2005 express edition?
what is the difference between Tabular and Matrix report?
Explain microsoft sql server functions?
How does normalization work?
What are orphan records?
How to receive output values from stored procedures?
Where sql server user names and passwords are stored in sql server? : sql server database administration
Explain about nested stored procedure?
How to execute multiple stored procedures at one time in sql server?
What is the data type of time?
