xml and sql server

[senthil]

how to get the sql server data through xml code

 

[Dino Chiesa [Microsoft]]

can you be more clear
you want the output from a SQL query to be presented in XML?

For SQL2000, you can use the "for xml" query format.