回答:declare @rtb table(FID int,FVal nvarchar(100))
declare @i int=1,@xh int=1,@inptstr nvarchar(1000)
set @inptstr='${输入字符串}'
while isnull(@inptstr,'')<>''
begin
set @xh=CHARINDEX(',',@inptstr,@xh)
if @xh>0
begin
insert into @rtb values(@i,LEFT(@inptstr,@xh-1))
select @i=@i+1,@inptstr=RIGHT(@inptstr,len(@inptstr)-@xh)
end
else
begin
insert into @rtb values(@i,@inptstr)
select @i=@i+1,@inptstr=''
end
end
select * from @rtb