CREATE PROCEDURE BOMJG
@id varchar(32) ,@wlbm varchar(32) AS
declare @cc int
select @cc = 1
insert into bomjg(id,guid,wlbm,cc) select @id,guid,clbm,@cc from bom where cpbm=@wlbm
while @cc > 0
begin
insert into bomjg(id,guid,wlbm,cc) select @id,bom.guid,bom.clbm,@cc+1 from bom,bomjg where bom.cpbm=bomjg.wlbm and bomjg.id=@id and bomjg.cc= @cc
select @cc = @cc + 1
end
上面存储过程提示:系统中已存在 bomjg 对象,难道存储过程中不能引用已存在的表吗?请指导! |