22,210
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE TabName2(ID INT PRIMARY KEY,Num INT )
INSERT INTO TabName2 SELECT 1,10
INSERT INTO TabName2 SELECT 2,20
UPDATE TabName2 SET ID=3-ID
--查看日志
SELECT * FROM::fn_dblog (null, null) WHERE Operation in('LOP_INSERT_ROWS','LOP_DELETE_ROWS','LOP_MODIFY_ROW') AND AllocUnitName LIKE '%TabName2%'
/*
0000006f:00000270:0002 LOP_MODIFY_ROW LCX_CLUSTERED
0000006f:00000270:0003 LOP_MODIFY_ROW LCX_CLUSTERED
*/
Create trigger tr_cT on T
after update --指定了动作为UPDATE,如果没有不会触发