CREATE TRIGGER TRIGGER_NAME
ON tab_visit
FOR DELETE
AS if delete(bh)
begin
declare @bh_old int
select @bh_old=(select bh from deleted)
end
...全文
776打赏收藏
有关 SQLserver7.0 中的Trigger 问题。。。。
我在SQLserver7.0 中编写触发器时,下面这段代码老是报有语法错误(在delete 旁边)请各位高手指正。 CREATE TRIGGER TRIGGER_NAME ON tab_visit FOR DELETE AS if delete(bh) begin declare @bh_old int select @bh_old=(select bh from deleted) end