怎么获得触发器update这条记录的ID~~~在线等

[w2512149]

怎么获得触发器update这条记录的ID~~~在线等

CREATE trigger t01_update ON [dbo].[TT01]
for update
AS
--Declare @i int
--Select @i=z --怎么获得TT01被update的ID~~~~~~~~~~~~~~~~~~~~~~~~
exec P_T03_1 @i,2

[bancxc]

select id from inserted

[ks_reny]

SELECT @i=z from deleted

[华夏小卒]

  Declare @i int 
  Select @i=(select id from inserted)  ----更新一条记录时，这样处理

[--小F--]

从deleted表中获取

[dawugui]

怎么获得触发器update这条记录的ID~~~在线等

CREATE trigger t01_update ON [dbo].[TT01]
for update
AS
--Declare @i int
--Select @i=z --怎么获得TT01被update的ID~~~~~~~~~~~~~~~~~~~~~~~~
exec P_T03_1 @i,2


--------------------

select @i = id from deleted