主题:关于trigger的问题
我用的是Sybase数据库,今天在写trigger的时候总是报错,我想盘但一下拥护在表中做什么操作,不知道应该怎么写,这是我写的代码,请看看
CREATE TRIGGER dbo.tro ON dbo.VWNS
FOR DELETE, INSERT, UPDATE AS
BEGIN
if exists(select * from inserted) not null
insert into VWNS
if exists(select * from deleted) not null
delete VWNS
if existe(select * from inserted,deleted) not null
update VENS
END
高手来指点一下,谢谢
CREATE TRIGGER dbo.tro ON dbo.VWNS
FOR DELETE, INSERT, UPDATE AS
BEGIN
if exists(select * from inserted) not null
insert into VWNS
if exists(select * from deleted) not null
delete VWNS
if existe(select * from inserted,deleted) not null
update VENS
END
高手来指点一下,谢谢