The following will create a stored procedure that has @testXml as an xml datatype. As my tables in the database store "testXml" in a typed xml field, can I "type" the @testXml parameter coming into my stored procedure using an item from the database's "Xml Schema Collections" What would be the DDL syntax
THANKS!
ALTER
PROCEDURE [dbo].[PearUpsertShapeImage]@id [bigint]
, @testXml [xml]AS
GO
Stored Procedure typed xml parameter DDL
urnabc
I believe I found the answer at:
http://msdn2.microsoft.com/en-us/library/ms184277.aspx
CREATE PROCEDURE SampleProc
@ProdDescription xml (Production.ProductDescriptionSchemaCollection)
AS