拆分字符串，并存入临时表中

create   table  #mytable(account  nvarchar ( 10 ))


declare   @oldstring   as   nvarchar ( 3000 )
declare   @tempstring   as   nvarchar ( 10 )
set   @oldstring = ' 10302299,10311441,10312196,10300104,10300297,10300381,10300509,10300564,10300679,10300732,10300743,10301331,10301338,10301359,10301414,10301785,10301787,10301910,10302121,10302160,10302220,10302269,10302983,10303821,10303913,10304481,10304659,10304671,10304680,10304691,10304698,10305624,10306061,10306815,10311833,10312241,10313045,10313120, '

while  ( PATINDEX ( ' %,% ' , @oldstring ) <> 0 )
begin
       set   @tempstring = substring ( @oldstring , 1 , PATINDEX ( ' %,% ' , @oldstring ) - 1 )
       insert   into  #mytable (account)  values  ( @tempstring ) -- 插入到临时表
       set   @oldstring = substring ( @oldstring , PATINDEX ( ' %,% ' , @oldstring ) + 1 , len ( @oldstring ))
end

select   *   from  #mytable

转载于:https://www.cnblogs.com/zhangjidong/archive/2005/12/14/297142.html