SQLSERVER创建触发器

发布时间：2020-12-12 13:03:43 所属栏目：MsSql教程来源：网络整理

导读：/*创建断言*/CREATE ASSERTION a_tb_user CHECK (SELECT COUNT(*) FROM tb_user = 10)/*创建触发器*/CREATE TRIGGER t_tb_user BEFORE INSERT ON tb_user REFERENCING NEWROW AS newUser FOR EACH ROW WHEN (10 =SELECT COUNT(*) FROM tb_use) INSERT INTO t

/*创建断言*/
CREATE ASSERTION a_tb_user
    CHECK (SELECT COUNT(*) FROM tb_user <= 10)

/*创建触发器*/
CREATE TRIGGER t_tb_user
    BEFORE INSERT ON tb_user
    REFERENCING
        NEWROW AS newUser
    FOR EACH ROW
        WHEN (10 >=SELECT COUNT(*) FROM tb_use)
            INSERT INTO tb_user(username,password,sex,age,birthday,email) values(newUser.username,newUser.password,newUser.sex,newUser.age,newUser.birthday,newUser.email)

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!