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 horizontal and vertical scaling?
How to search for a string in all stored procedure in sql server?
How many levels of sp nesting are possible?
Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
User wants only to display only pdf as export option in report manager. How to achieve this?
your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration
What is table valued function and scalar valued functions?
How global temporary tables are represented and its scope?
Explain acid?
How many types of stored procedures are there in sql server?
How many types of the database links?
How to list all columns in a table using odbc_columns()?
How do you handle datasets larger than 50 gb?
What is the difference between executequery () and executeupdate ()?
Explain few of the new features of sql server 2008 management studio
