DECLARE @idoc int DECLARE @doc xml
SET @doc ='
EXEC sp_xml_preparedocument @idoc OUTPUT, @doc
SELECT csif_cStateID FROM OPENXML (@idoc, '/condition/State') WITH (csif_cStateID varchar(15)) EXEC sp_xml_removedocument @idoc
DECLARE @docHandle int declare @xmlDocument nvarchar(max) -- or xml type set @xmlDocument = N'
' EXEC sp_xml_preparedocument @docHandle OUTPUT, @xmlDocument -- Use OPENXML to provide rowset consisting of customer data. --INSERT Customers --SELECT * --FROM OPENXML(@docHandle, N'ROOT/Customers/Orders') -- WITH Customers -- Use OPENXML to provide rowset consisting of order data. --INSERT Orders --SELECT * --FROM OPENXML(@docHandle, N'//Orders') -- WITH Orders -- Using OPENXML in a SELECT statement. SELECT * FROM OPENXML(@docHandle, N'/Item',2) WITH (SoNo nchar(20) , ItemID nvarchar(10),EditionCD nvarchar(10),ImprintCD nvarchar(10)) EXEC sp_xml_removedocument @docHandle --EXEC sp_xml_preparedocument @idoc OUTPUT, @doc -- --SELECT reqno --FROM OPENXML (@idoc, '/root/CourierID',1) --WITH (Reqno varchar(15))
----合併行轉列 from (select distinct rcpi_cCartonContentID,rcpi_iCartonProductID from #tempOldRcpi ) a Outer apply ( select stuff( replace( replace ( (select distinct isnull(so,'''') as so from #tempOldRcpi b where b.rcpi_iCartonProductID=a.rcpi_iCartonProductID for xml auto),'''',''''),1,1,'''') as So
) as c'
最新评论