SQL字符串转换为数组
--select dbo.CheckStrLikeInArr(2,'d','sde,df,aad,d,fgsa,fgd')Create function CheckStrLikeInArr(@liketype int=0, --like类型(0为为@keyword%,2为) 一般只用0@keyword as varchar(50), --要检查的关键字@sArr as varchar(5000) --数组)
returns nvarchar(max)as begindeclare @str varchar(5000) set @str=@sArrdeclare @start int declare @result nvarchar(max) set @result=''
set @start=1declare @temp nvarchar(20);while @start
页:
[1]