SqlServer下通过XML拆分字符串的方法
实现代码如下: DECLARE @idoc int; DECLARE @doc xml; set @doc=cast(''+replace(@SelectedProjectArray,',','')+'' as xml) EXEC sp_xml_preparedocument @Idoc OUTPU
实现代码如下: DECLARE @idoc int; DECLARE @doc xml; set @doc=cast(''+replace(@SelectedProjectArray,',','')+'' as xml) EXEC sp_xml_preparedocument @Idoc OUTPU