DECLARE @idoc int;
DECLARE @doc xml;
set @doc=cast('
EXEC sp_xml_preparedocument @Idoc OUTPUT, @doc
SELECT ProjID FROM OPENXML (@Idoc, '/Root/item',2)
WITH (
[ProjID] varchar(10)
)
SELECT ProjID FROM OPENXML (@Idoc, '/Root/item',2)
WITH (
[ProjID] varchar(10)
)
