请问如下代码,sql是如何运行的,我实在看不懂他的含义
declare @i int
select @i = 1
while (@i<=10)
begin
update 物料清单 set 低层码 = b.低层码+1 from 物料清单 as a,
(select * from 物料清单) as b
where a.父项编号 = b.物料编号
select @i = @i + 1
end
declare @i int
select @i = 1
while (@i<=10)
begin
update 物料清单 set 低层码 = b.低层码+1 from 物料清单 as a,
(select * from 物料清单) as b
where a.父项编号 = b.物料编号
select @i = @i + 1
end
select a.*, b.* from 物料清单 as a, 物料清单 as b where a.父项编号 = b.物料编号