SQL Server actually supports two kinds of XML objects: typed and untyped. What distinguishes the two is whether the XML column, variable, or parameter is associated with a specific schema collection, a database entity (like a table or stored procedure) that specifies the structure and data types that an XML […]

SQL Server Typed XML using XSD