gipasoft

XSD Schema to an XML field

Feb 26th, 2014
314
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.98 KB | None | 0 0
  1. USE dbFad01_roadmapinanestesia
  2.  
  3. CREATE XML SCHEMA COLLECTION SponsorSchema AS
  4. N'<?xml version="1.0" encoding="UTF-16"?>
  5. <xs:schema id="sponsors" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
  6.  <xs:element name="sponsors" msdata:IsDataSet="true" msdata:Locale="en-US">
  7.    <xs:complexType>
  8.      <xs:choice minOccurs="0" maxOccurs="unbounded">
  9.        <xs:element name="sponsor" nillable="true">
  10.          <xs:complexType>
  11.            <xs:simpleContent msdata:ColumnName="sponsor_Text" msdata:Ordinal="0">
  12.              <xs:extension base="xs:string">
  13.              </xs:extension>
  14.            </xs:simpleContent>
  15.          </xs:complexType>
  16.        </xs:element>
  17.      </xs:choice>
  18.    </xs:complexType>
  19.  </xs:element>
  20. </xs:schema>' ;
  21. GO
  22. -- Verify - list of collections in the database.
  23. SELECT *
  24. FROM sys.xml_schema_collections
  25. -- Verify - list of namespaces in the database.
  26. SELECT name
  27. FROM sys.xml_schema_namespaces
Advertisement
Add Comment
Please, Sign In to add comment