------ 执行以下存储过程后 只能将最后一行数据 插入HT_SALE_REC_COMPANY表 我想要逐行插入 改怎么做?
set @i =1
select @count =count(*) from Sheet1$
while(@i<=@count)
begin
delete from HT_SALE_REC_COMPANY
delete from ht_sale_comp_agree select @rec_no=rtrim(ltrim(rec_no)),@com_name=rtrim(ltrim(comp_name))
from Sheet1$
where id=@i insert into HT_SALE_REC_COMPANY(rec_no,com_name)
values(@rec_no,@com_name)
-----这里没有逐行插入数据
set @i =@i+1
end
set @i =1
select @count =count(*) from Sheet1$
while(@i<=@count)
begin
delete from HT_SALE_REC_COMPANY
delete from ht_sale_comp_agree select @rec_no=rtrim(ltrim(rec_no)),@com_name=rtrim(ltrim(comp_name))
from Sheet1$
where id=@i insert into HT_SALE_REC_COMPANY(rec_no,com_name)
values(@rec_no,@com_name)
-----这里没有逐行插入数据
set @i =@i+1
end
delete from HT_SALE_REC_COMPANY
delete from ht_sale_comp_agree
写到循环外
当然之前的数据都被DELETE掉了,把那2句DELETE放到WHILE循环前就OK了
对的 那该如何更正 ?
delete from HT_SALE_REC_COMPANY
delete from ht_sale_comp_agree
有问题啊``
insert HT_SALE_REC_COMPANY (rec_no,com_name) select rtrim(ltrim(rec_no)),rtrim(ltrim(comp_name)) from sheet$1
delete from HT_SALE_REC_COMPANY
delete from ht_sale_comp_agree
这2句提到while循环前