xscp_insertupdate.sql

vbsql做的销售管理课程设计样本不完全仅为范例

USE cpxs
GO
IF EXISTS(SELECT name FROM sysobjects 
WHERE xtype= 'TR' AND name ='xscp_tri')
DROP TRIGGER xscp_tri
GO
CREATE  TRIGGER xscp_tri on dbo.xscp
FOR INSERT,UPDATE
AS
BEGIN
IF((SELECT ins.cpbh from inserted ins) NOT IN
 		(SELECT cpbh FROM cp))
  	ROLLBACK
/*对当前事务回滚，即恢复到插入前的状态*/
END