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
What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?
What is nonclustered index on computed columns?
Distinguish between commit and rollback?
What is exporting utility?
Tell me what is the significance of null value and why should we avoid permitting null values?
Do you know what is openxml in sql server?
How to use group functions in the select clause in ms sql server?
Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?
What are the database objects? : SQL Server Architecture
What happens when transaction log is full?
What is it unwise to create wide clustered index keys?
What are four major operators that can be used to combine conditions on a where clause?
Explain the dirty pages?
What is difference between delete and truncate commands?
What are the 10 characteristics of data quality?
