在表中不允许执行某些insert操作
USE [AdventureWorks]
GO
CREATE TRIGGER [Sales].
[]iStore].
[Store]
AFTER INSERT AS
BEGIN
SET NOCOUNT
ON;
BEGIN TRY
--判断是否插入记录的CustomerID字段是否已经在[Sales].[Individua]表中存在相同的记录
IF EXISTS (
SELECT * FROM inserted
INNER JOIN [Sales].
[individua]
ON inserted.
[CustomerID] = [Sales].
[individua].
[CustomerID])
BEGIN
--若有相同记录，则回滚事物
IF @@TRANCOUNT > 0
BEGIN
ROLLBACK TRANSACTION;
END
END;
END TRY
BEGIN CATCH
EXECUTE [dbo].
[uspPrintError];
--调用存储过程，在错误日志表中记录错误产生详情
IF @@TRANSCOUNT > 0
BEGIN
ROLLBACK TRANSACTION;
END
EXECUTE [dbo].
[uspPrintError];
END CATCH;
END ;
GO
转载于:https://www.cnblogs.com/siyunianhua/archive/2011/12/26/2302672.html
