SqlServer中通过XML拆分字符串

 

代码

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 )
)

 

 

转载于:https://www.cnblogs.com/zfqbt/archive/2010/06/10/1755766.html