SQL Server Performance

xml schema

Discussion in 'SQL Server 2005 General Developer Questions' started by arkiboys, Oct 15, 2008.

  1. arkiboys Member

    I have to use an existing store procedure (sp).
    The sp requires several parameters.
    ALTER PROCEDURE [dbo].[usp_INS_MyData]
    @System xml(CONTENT [dbo].StringList),
    @SystemDescription nvarchar(1000),
    ...
    I have searched the sql server database and I have found that The above type xml(CONTENT [dbo].StringList) is a Type under XML Schema Collections (See below).
    Question:
    I would like to pass the following xml into the @System parameter of the sp
    <value>company Name</value>
    <value>address</value>
    I am not sure what to wrap around my xml so that I can pass onto the @system for the sp.
    Can you help please?
    Thanks
    This is the xml schema:
    CREATE XML SCHEMA COLLECTION [dbo].[StringList] AS N'<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:t="http://schemas.myCompany.com/myProject/[app]/stringList/1.0" targetNamespace="http://schemas.myCompany.com/myProject/[app]/stringList/1.0" elementFormDefault="qualified"><xsd:element name="stringList"><xsd:complexType><xsd:complexContent><xsd:restriction base="xsd:anyType"><xsd:sequence maxOccurs="unbounded"><xsd:element name="value" type="xsd:string" /></xsd:sequence></xsd:restriction></xsd:complexContent></xsd:complexType></xsd:element></xsd:schema>'

Share This Page