declare @ids varchar(50)
declare @str varchar(200)
declare @i int
set @ids=’11,222,333’+’,’
while @ids <>”
begin
set @str = substring(@ids,1,charindex(‘,’,@ids)-1)
set @ids = replace(@ids,@str+’,”)
select @str,@ids
end
SQL命令解析字符串。
dawei
2021年1月23日 22:30
declare @ids varchar(50)declare @str varchar(200)declare @i intset @ids=11,222,333+,while @ids beginset @str = substring(@ids,1,charindex(,,@ids)-1)set @ids = replace(@ids,@str+,,)select @str,@idsend
