22,300
社区成员




CREATE TRIGGER before_insert_jieyue ON [dbo].[借阅信息表]
FOR INSERT, UPDATE
AS
BEGIN
IF EXISTS ( SELECT 1
FROM dbo.读者信息表
WHERE 读者编号 IN ( SELECT 读者编号
FROM inserted )
AND 状态 NOT IN ( '正常' ) )
PRINT '账号不正常'
ROLLBACK
END