Database Trigger Use

/**************************************************************************

    说明：  通过触发器进行排除插入已存在的用户名的的操作

**************************************************************************/
CREATE TRIGGER trigger_student_insert
ON student
AFTER INSERT
AS
    IF EXISTS(SELECT * FROM student,inserted WHERE student.stuName=inserted.stuName)
BEGIN
    print 'name is san exist'
    rollback transaction
END


insert into student values('tong',1,getDate(),'guangzhou')

/**************************************************************************

    说明：  通过触发器进行排除插入分数大于100的操作

**************************************************************************/

USE school
GO
CREATE TRIGGER trigger_result_insert
ON result
AFTER INSERT
AS
    IF(SELECT mark FROM student,inserted WHERE student.stuId=inserted.stuId)>100
BEGIN
    print 'not insert mark > 100'
    rollback transaction
END


INSERT INTO result values(3,3,101).