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
Generating XML based on XMLSchema in a SQLSERVER2005 Stored procedure
Hot Topic
- how to synchronize between sql mobile 2005 & sql 2000?
- Noob questions about Reporting Services
- No grouping?
- SQL Server 2005 CTP Release Candidate Sept - unexpected failure during setup wizard
- Good SSIS Example tutorial - User Variables
- Error in the PROCEDURE....
- How to format in SSMS?
- Configure Report Server - Web Service Identity
- Interfacing with SQL Server 2005 EXPRESS
- repeatwith property
SQL Server
- How to install sql express september ctp.
- Using CASE statement within GROUP BY
- Migrating RS
- Should you save results of intermediate data flow steps to temporary tables or raw files?
- Very Urgent Help Guys
- identifying the invalid procedure
- SQL Server 2005 fails while installing on a cluster.
- Change of DOMAIN causes encryption key problems
- Huge disk usage during aggregation processing
- Pre and PostExecute Event handler called more than once
Generating XML based on XMLSchema in a SQLSERVER2005 Stored procedure
maleshkov2006
Can sqlserver 2005 generete XML schema for the whole database
Can anyone suggest us on this.
thanks
oak-net
Alyn
thanks for the reply.
vaishu
Sid Sidnew
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