how to generate XML out of QUERY?
Answer / 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 |
Why we need sql server?
What is a ddl statement?
my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions
What is built-in/administrator?
How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?
What is the data type of time?
How do I manually uninstall an instance of sql server 2016?
List the different index configurations possible for a table?
I am Having tables T1 and T2 both having same data how to check (or) compare the data in both table are same?
What value could be assigned to Varchar Type?
What is the difference between osql and query analyzer?
What are the new features in SQL Server 2005 when compared to SQL Server 2000?