sql 中的xml类型用途
DECLARE @Ids xml
set @Ids ='
SELECT ParamValues.ID.value('.','int') as ID
FROM @Ids.nodes('/ID') as ParamValues(ID)
可以当参数In使用。
DECLARE @Ids xml
set @Ids ='
Select * from Table1 Where ID In(
SELECT ParamValues.ID.value('.','int') as ID
FROM @Ids.nodes('/ID') as ParamValues(ID)
)
作者“cnming”