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 happens if you are trying to access a schema not owned by you?
What is etl - extraction, transformation, and loading?
What are the advantages of policy management?
Explain how to maintain a fill factor in existing indexes?
Explain what are commit and rollback in sql?
What are subqueries in sql server? Explain its properties.
What is reference section?
What the class forname () does?
What do you mean by normalisation?
Explain alternate key, candidate key and composite key in sql server?
How to filter out duplications in the returning rows in ms sql server?
How to connect php with different port numbers?
What happens if null values are involved in datetime operations?
How to find the list of fixed hard drive and free space on server?
What is difference between aggregate and analytic function?