22,209
社区成员
发帖
与我相关
我的任务
分享
USE tempdb
GO
IF OBJECT_ID('t') IS NOT NULL DROP TABLE t
GO
CREATE TABLE t(
m INT
)
SET NOCOUNT ON
INSERT INTO t VALUES(4),(5)
GO
IF OBJECT_ID('dbo.trig_t_I') IS NOT NULL DROP TABLE dbo.trig_t_I
GO
-- =============================================
-- Author: j
-- Create date: 2018-09-22
-- Description:
-- =============================================
CREATE TRIGGER dbo.trig_t_I
ON dbo.t
AFTER INSERT
AS
BEGIN
SET NOCOUNT ON;
IF exists(SELECT 1 FROM INSERTED AS i WHERE EXISTS(
SELECT 1 FROM t WHERE i.m<t.m
))
BEGIN
RAISERROR ('新插入的值比旧值小,不允许.', -- Message text.
16, -- Severity.
1 -- State.
);
END
END
GO
INSERT INTO t(m) VALUES (6)
INSERT INTO t(m) VALUES (3)
/*
新插入的值比旧值小,不允许.
*/