--在存储过程中分解即可 while charindex(',',@stcdList)>0 begin print left(@stcdList,charindex(',',@stcdList)-1) --left(@stcdList,charindex(',',@stcdList)-1)就是分解好的每一部分, set @stcdList= stuff(@stcdList,1,charindex(',',@stcdList),'') end
--在存储过程中分解即可 while charindex(',',@stcdList)>0 begin print left(@stcdList,charindex(',',@stcdList)-1) --left(@stcdList,charindex(',',@stcdList)-1)就是分解好的每一部分, --把 left(@stcdList,charindex(',',@stcdList)-1)当做@stcd --在此写下你的操作即可 set @stcdList= stuff(@stcdList,1,charindex(',',@stcdList),'') end
用字符串寫入臨時表,或05用xml處理 declare @T table(ID nvarchar(20)) declare @stcdlist nvarchar(1000),@s nvarchar(2000) set @stcdlist='''50100100'',''50103000''' set @s='select '+replace(@stcdlist,',',' union all select ') insert @T exec(@s)select * from @T(2 個資料列受到影響) ID -------------------- 50100100 50103000(2 個資料列受到影響)
--在存储过程中分解即可
while charindex(',',@stcdList)>0
begin
print left(@stcdList,charindex(',',@stcdList)-1)
--left(@stcdList,charindex(',',@stcdList)-1)就是分解好的每一部分,
--把 left(@stcdList,charindex(',',@stcdList)-1)当做@stcd
--在此写下你的操作即可
set @stcdList= stuff(@stcdList,1,charindex(',',@stcdList),'')
end
declare @T table(ID nvarchar(20))
declare @stcdlist nvarchar(1000),@s nvarchar(2000)
set @stcdlist='''50100100'',''50103000'''
set @s='select '+replace(@stcdlist,',',' union all select ')
insert @T exec(@s)select * from @T(2 個資料列受到影響)
ID
--------------------
50100100
50103000(2 個資料列受到影響)