SqlServer下通过XML拆分字符串的方法
(编辑:jimmy 日期: 2024/12/24 浏览:3 次 )
复制代码 代码如下:
DECLARE @idoc int;
DECLARE @doc xml;
set @doc=cast('<Root><item><ProjID>'+replace(@SelectedProjectArray,',','</ProjID></item><item><ProjID>')+'</ProjID></item></Root>' as xml)
EXEC sp_xml_preparedocument @Idoc OUTPUT, @doc
SELECT ProjID FROM OPENXML (@Idoc, '/Root/item',2)
WITH (
[ProjID] varchar(10)
)
DECLARE @idoc int;
DECLARE @doc xml;
set @doc=cast('<Root><item><ProjID>'+replace(@SelectedProjectArray,',','</ProjID></item><item><ProjID>')+'</ProjID></item></Root>' as xml)
EXEC sp_xml_preparedocument @Idoc OUTPUT, @doc
SELECT ProjID FROM OPENXML (@Idoc, '/Root/item',2)
WITH (
[ProjID] varchar(10)
)
下一篇:sqlserver 2000数据库同步 同步两个SQLServer数据库的内容