---去除字符串中重復的值函數
create function RemoveRepeatString(@str nvarchar(2000))
returns nvarchar(2000)
as
begin
declare @result nvarchar(2000),@temp nvarchar(1000)
set @result=''
set @temp=''
while(charindex(',',@str)<>0)
begin
set @temp=substring(@str,1,charindex(',',@str))
if(charindex(@temp,@result)<=0)
set @result=@result+@temp
set @str=stuff(@str,1,charindex(',',@str),'')
end
return @result
end
GO
--test
--select dbo.RemoveRepeatString('你好啊,你,你好啊,1,23,1')
create function RemoveRepeatString(@str nvarchar(2000))
returns nvarchar(2000)
as
begin
declare @result nvarchar(2000),@temp nvarchar(1000)
set @result=''
set @temp=''
while(charindex(',',@str)<>0)
begin
set @temp=substring(@str,1,charindex(',',@str))
if(charindex(@temp,@result)<=0)
set @result=@result+@temp
set @str=stuff(@str,1,charindex(',',@str),'')
end
return @result
end
GO
--test
--select dbo.RemoveRepeatString('你好啊,你,你好啊,1,23,1')