Query SQL text to XML

[mtawk]

hi,

Is there any tool that can convert SQL Query Text to XML format? or a predefined XML format to store Query SQL text?

Thanks

 

[mrdenny]

Not that I know of.

Why would you want to store T/SQL statements as XML? Nothing would be able to run them without turning them back into T/SQL.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2008 Implementation and Maintenance / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Admin (SQL 2005/2008) / Database Dev (SQL 2005)

My Blog

 

[starsky51]

<statement>SELECT * FROM blah</statement>

 

[mrdenny]

Posting a sample XML document with a SQL query in it doesn't answer my initial question.

Why would you want to store T/SQL statements as XML?

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL BI 2005 / SQL 2008 DBA / SQL 2008 DBD / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP Database Admin (SQL 2005/2008) / Database Dev (SQL 2005/2008 / BI Dev (SQL 2005)

My Blog