如何遍历inserted表中数据？

[seafly521]

触发器中，每次有多条数据，怎么样遍历每条数据。
以下代码好像只能在inserted表中只有一条数据是才管用，由于对数据库不是太了解 谁能改一下在多条数据下也能使用用。

CREATE TRIGGER StorageUp  ON [dbo].[Storage] 
FOR  UPDATE
AS
declare @Number Float(8)
set @Number=(select SNumber  from inserted)
update Goods set GNumber=GNumber+@Number  where GoodID=(select GoodID from inserted)

[AcHerat]

CREATE TRIGGER StorageUp  ON [dbo].[Storage] 
FOR  UPDATE
AS
update a
set a.GNumber=a.GNumber+b.Number 
from Goods a,inserted b 
where a.GoodID=b.GoodID

[AcHerat]

CREATE TRIGGER StorageUp  ON [dbo].[Storage] 
FOR  UPDATE
AS
update a
set a.GNumber=a.GNumber+b.SNumber 
from Goods a,inserted b 
where a.GoodID=b.GoodID
go

--将inserted作为一个表，根据某个表去更新另一个表楼主应该会吧！

[seafly521]

多谢多谢！