begin
end
if(charindex(@temp,@result)<=0)
as
while(charindex(',',@str)<>0)
begin
create function StringRemove(@str nvarchar(2000))

set @str=stuff(@str,1,charindex(',',@str),'')

复制代码 代码如下:

---去除字符串中重復的值函數
--測試

declare @result nvarchar(2000),@temp nvarchar(1000)
set @result=@result+@temp
set @temp=''
set @result=''
select dbo.StringRemove('塗聚文,塗,塗聚文,1,23,1')
end
returns varchar(2000)
--('塗聚文','塗','塗聚文','1','23','1')
return @result
set @temp=substring(@str,1,charindex(',',@str))
GO