declare @arr varchar(max)
declare @people varchar(100)
declare @find int
--要拆分的字符串数组,逗号分隔
set @arr='AA,BB,CC,DD'
set @find=1
while @find>0
begin
set @find=charindex(',',@arr)
set @people=SUBSTRING(@arr,1,@find-1)
--print 'find='+convert(varchar(100),@find)
--print convert(varchar(100),@find)+ @people
print @people
--查找敏感词
select @people,[id],[content],[createtime] from [Bus_InformationInfo] a
where [Content] like '%'+@people+'%'
set @arr=SUBSTRING(@arr,@find+1,10000)
-- print 'arr:'+ @arr
if LEN(@arr)=0
begin
-- 退出循环
break
end
if charindex(',',@arr)=0
begin
--最后一个词
set @arr=@arr+','
end
end
sqlserver字符串数组拆分打印单个元素
最新推荐文章于 2024-03-22 09:31:34 发布