大家好，下面是一段SQL语句，谁帮解一下。

来源：百度知道 编辑：UC知道 时间：2024/05/05 08:50:18
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
ALTER TRIGGER [TRG_DELETE_Ejob] ON dbo.Ejob 何解？
FOR DELETE 何解？
AS 何解？
DELETE FROM ATInvoice where ejob in (select ejob from deleted)
DELETE FROM EjobGoods where ejob in (select ejob from deleted)
DELETE FROM EjobGoods1 where ejob in (select ejob from deleted)
DELETE FROM EjobVerify where ejob in (select ejob from deleted)
DELETE FROM EJOBPROGRESS WHERE EJOB IN (SELECT EJOB FROM DELETED)
DELETE FROM EjobContainer where Ejob in (select ejob from deleted)
DELETE FROM EjobContainer4Custom where Ejob in (select ejob from deleted)
DELETE FROM EjobCrate where Ejob in (select ejob from deleted)
DELETE FROM EjobGCrate where Ejob in (select ejob from deleted)
DELETE FROM DocumentAccessUsers where Document = 5 and DocumentID in (select Ej

SQL触发器语法参考
Create TRIGGER trigger_name
ON { table | view }
[ WITH ENCRYPTION ]
{
{ { FOR | AFTER | INSTEAD OF } { [ Insert ] [ , ] [ Update ] }
[ WITH APPEND ]
[ NOT FOR REPLICATION ]
AS
[ { IF Update ( column )
[ { AND | or } Update ( column ) ]
[ ...n ]
| IF ( COLUMNS_UpdateD ( ) { bitwise_operator } updated_bitmask )
{ comparison_operator } column_bitmask [ ...n ]
} ]
sql_statement [ ...n ]
}
}

参数
trigger_name

是触发器的名称。触发器名称必须符合标识符规则，并且在数据库中必须唯一。可以选择是否指定触发器所有者名称。

Table | view

是在其上执行触发器的表或视图，有时称为触发器表或触发器视图。可以选择是否指定表或视图的所有者名称。

WITH ENCRYPTION

加密 syscomments 表中包含 Create TRIGGER 语句文本的条目。使用 WITH ENCRYPTION 可防止将触发器作为 SQL Server 复制的一部分发布。

AFTER

指定触发器只有在触发 SQL 语句中指定的所有操作都已成功执行后才激发。所有的引用级联操作和约束检查也必须成功完