Generating XML based on XMLSchema in a SQLSERVER2005 Stored procedure

Hot Topic

Restrict report to 1 page of A4 and have multiple columns
Issue with SqlUserDefinedAggregate
Standard deviation calculation
Uninstalling SQL Server September CTP failed
How to call a dot net assembly from ssis
MSDAORA error on one machine
SQL Server 2005 JDBC Driver 1.0 error in using XA datasource
Error in SQL 2005 cluster installation
Data Mining - Scalar Mining Structure Column Data type error...
OLE DB or ADO?? plz give me a suggestion!

SQL Server

SQL reporting Services (report toolbar)
Lookup error with code 0x80070057
Error in X-Path Query
AMO "Scripter" Class - Help
sql server 2005 RS multi-value params june ctp
Problem w/ Script Task accessing Directory Services
UK Datetime parameter problem SQL 2005 RS
SSIS COLOur Settings
Log Reader Agent Lacks A Required Privilege
Plug-in Algorithms in Managed Code

Generating XML based on XMLSchema in a SQLSERVER2005 Stored procedure

Can a stored procedure in SQLSERVER 2005 generate XMLdata based on the schema

Are there any features in SQLServer2005 to achieve this

Please suggest me in this regard.

Thanks

vaishu

Answer this question

Generating XML based on XMLSchema in a SQLSERVER2005 Stored procedure

Ryan_H

thanks for the reply.

vaishu
Michael Lutz

Yes this is possible. Michael Rys' article about FOR XML support and the Xml datatype shows examples of this:

http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnsql90/html/forxml2k5.asp
Eeyore116
Can sqlserver 2005 generete XML schema for the whole database

Can anyone suggest us on this.

thanks

oak-net
Generating XML based on XMLSchema in a SQLSERVER2005 Stored procedure

Answer this question