select * from [table name] for xml auto (or) select * from [table name] f

how to generate XML out of QUERY?

Question Posted / mahendra raja

1 Answers
5264 Views
McAfee, I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

How to create a user name in a database?

1102

Why I am getting "the microsoft .net framework 2.0 in not installed" message?

1051

What is a rownum?

1059

What is “asynchronous” communication in sql server service broker?

1080

Can we use pragma autonomous_transaction in trigger?

1014

What is scan table/view and seek table/view when its occurs? : sql server database administration

1089

What stored by the msdb? : sql server database administration

1052

explain different types of constraints? : Sql server database administration

1000

What is outer join in sql server joins?

1184

What are SSL and TSL protocols?

1033

What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?

1101

What is field with example?

976

How to create a view with data from multiple tables?

1063

What are the advantages of user defined function?

1042

What is cursor in ms sql server?

1202