An SQL SELECT statement can have a FOR XML clause that returns the query result as XML instead of a rowset. You can also have a stored procedure that has a SELECT statement with a FOR XML clause. FOR ...

You can configure the [!INCLUDEadaptersqlshort] to receive periodic data-change messages for SQL Server tables or views by using SELECT statements or stored procedures that include a FOR XML ...

Hi, I'm new to the Sql. I have a query in which i need to include version = '3.0' in the root tag before the namespaces starts or end of the namespaces but should be in the root.