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日 20:16
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
本文来自网络，不代表青岛站长网立场。转载请注明出处： https://www.0532zz.com/html/shujuku/mssql/20210123/16656.html
