在Sql Server中创建一个触发器，提示before不是可以识别的触发器，怎么解决？
BEFORE DELETE
for each row
AS
begin
if exists(select * from 车次 where 车辆编号=(select 车辆编号 from deleted))
begin
delete from 车次 where 车辆编号=(select 车辆编号 from deleted)
end
end
最新回答
下一站等候
2023-09-27 05:05:02
触发器
语言里面没有before，只有forSQL触发器语法
语法
CREATE TRIGGER trigger_name
ON { table | view }
[ WITH ENCRYPTION ]
{
{ { FOR | AFTER | INSTEAD OF } { [ INSERT ] [ DELETE ] [ UPDATE ] }
枯隐迟[ WITH APPEND ]
没李[ NOT FOR REPLICATION ]
AS
[ { IF UPDATE ( column )
[ { AND | OR } UPDATE ( column ) ]
[ ...n ]
| IF ( COLUMNS_UPDATED ( ) updated_bitmask )
column_bitmask [ ...n ]
} ]
sql_statement [ ...n ]
携腔 }
}
有多少爱能够胡来
2020-07-15 17:01:06
热门标签
