Tag Archives: xml

XML Schema Creation in SQL Server 2005

Here’s an interesting approach for creating a quick and dirty schema to get you started with XML. DECLARE @schema xml SET @schema = (SELECT * FROM schema.TABLE FOR XML AUTO, ELEMENTS, XMLSCHEMA(’SchemaName’)) SELECT @schema I don’t have the source, but … Continue reading

Posted in SQL Toolbox | Tagged , , | Leave a comment

XML Modification

XML Modification for fun and profit Continue reading

Posted in SQL Server Development | Tagged , , | Leave a comment

XML Nodes Query

A reminder of how the nodes query works inside Microsoft SQL Server. Continue reading

Posted in SQL Server Development, SQL Toolbox | Tagged , | Leave a comment