改成:
create function hy1 (@str varchar(100))
return @str
as
begin
--declare @str varchar(100)
select charindex(',',@str)
while (charindex(',',@str)>0)
begin
set @str= substring(@str,charindex(',',@str)+1,len(@str))
end
end
create function hy1 (@str varchar(100))
return @str
as
begin
--declare @str varchar(100)
select charindex(',',@str)
while (charindex(',',@str)>0)
begin
set @str= substring(@str,charindex(',',@str)+1,len(@str))
end
end
begin
return @str
end