对 inserted 或 deleted 表中对 text 或 image 列的引用表现为 NULL。 除非sp_dbcmptlevel 的兼容级别设置为 60 或 65,否则不再允许对 inserted 或 deleted 表中 text 或 image 列的引用。
根据 sp_dbcmptlevel 的设置,当引用 inserted 或 deleted 表中 text 或 image 列时,当使用 CREATE TRIGGER 时,行为应不同。
根据 sp_dbcmptlevel 的设置,当引用 inserted 或 deleted 表中 text 或 image 列时,当使用 CREATE TRIGGER 时,行为应不同。
FOR delete
AS
delete table2 where 编号 in (select 编号 from deleted)2、on delete restrict:CREATE TRIGGER xx ON table1
FOR delete
AS
if exists(select * from deleted where 列1>10)
rollback tran3、on delete set nullCREATE TRIGGER xx ON table1
FOR delete
AS
update table2 set xx=null where 主键 in (select 主键 from deleted)