Which code segment should you use?

You have an XML schema collection named Sales.InvoiceSchema. You need to declare a
variable of the XML type named XML1. The solution must ensure that XML1 is validated by
using Sales.InvoiceSchema.
Which code segment should you use?
To answer, type the correct code in the answer area.

You have an XML schema collection named Sales.InvoiceSchema. You need to declare a
variable of the XML type named XML1. The solution must ensure that XML1 is validated by
using Sales.InvoiceSchema.
Which code segment should you use?
To answer, type the correct code in the answer area.

Answer: DECLARE @XML1 XML(Sales.InvoiceSchema)

Explanation:
Reference:
http://msdn.microsoft.com/en-us/library/ms176009.aspx



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Aristocat

Aristocat

DECLARE @XML1 xml
Set @XML1 = N’
….
…’
CREATE XML SCHEMA COLLECTION Sales.InvoiceSchema AS @XML1