DECLARE @doc xml;
DECLARE @DocHandle int
DECLARE @model nvarchar(255)
SET @model='KF-25U2-B'
SET @doc=(SELECT 明细 FROM 家电下乡空调 WHERE 型号=@model)
EXEC sp_xml_preparedocument @DocHandle OUTPUT, @doc
SELECT @model AS 型号, *
FROM OPENXML (@DocHandle, '/ROOT/PRODUCT',2)
WITH (PD_NAME nvarchar(max),
PD_ID nvarchar(max),
PD_TYPE nvarchar(max),
PD_SERIAL nvarchar(max))
EXEC sp_xml_removedocument @DocHandle
|