sql语句循环插入时出错,求帮助!!
if @as_xtyhdm is not null and rtrim(@as_xtyhdm)<>''
begin
set @ln_i=charindex(',',@as_xtyhdm);
if @ln_i=0
begin
insert into xst53 ( xsczhm,
xtyhdm)values
(@as_xsczhm,
@as_xtyhdm);
end
else
begin
set @as_xtyhdm=@as_xtyhdm+',';
while @ln_i>=1
begin
set @ls_sql=substring(@as_xtyhdm,1,@ln_i-1);
insert into xst53 ( xsczhm,
xtyhdm)values
(@as_xsczhm,
@ls_sql);
set @as_xtyhdm=substring(@as_xtyhdm,@ln_i+1,len(@as_xtyhdm)-@ln_i);
set @ln_i=charindex(',',@as_xtyhdm);
end
end
end