62,041
社区成员
发帖
与我相关
我的任务
分享
declare @c varchar(max)
,@d varchar(max)
,@Temp_Variable varchar(max)
,@result varchar(max)
set @c='131,132,133,134,139,137,159,155'+','--注意在@c补个逗号
set @d='131,132,133,134,139,137,159,155,185,186,189,135'
set @result=''
while(LEN(@d) > 0)
begin
if(CHARINDEX(',',@d) = 0)
begin
set @Temp_Variable = @d
set @d = ''
end
else
begin
set @Temp_Variable = LEFT(@d,CHARINDEX(',',@d)-1)
set @d = RIGHT(@d,LEN(@d)-LEN(@Temp_Variable)-1)
end
if(CHARINDEX(@Temp_Variable+',',@c)<1)
begin
set @result+=@Temp_Variable+','
end
end
if(@result!='')
begin
set @result=LEFT(@result,LEN(@result)-1)
end
select @result