阿亮写的。
declare @str varchar(250)
set @str = '110,12,13,15'
declare @currPos int
declare @item varchar(250)
set @currPos = charindex(',',@str)
if ( @currPos > 0 )
begin
set @item = substring(@str,1,@currPos-1)
insert TA1 values(@item)
while ( charindex(',',@str,@currPos+1) > 0 )
begin
set @item = substring(@str,@currPos+1,(charindex(',',@str,@currPos+1)-@currpos-1))
set @currPos = charindex(',',@str,@currPos+1)
insert TA1 values(@item)
end
end
set @item = substring(@str,@currPos+1,len(@str)-@currPos+1)
insert TA1 values(@item)