34,590
社区成员
发帖
与我相关
我的任务
分享
CREATE TRIGGER tri_ins
ON emp
FOR INSERT
AS
DECLARE @deptno_d char(10),
@years int
SELECT @deptno_d = dept.deptno, @years = years
FROM emp,dept
IF INSERT(deptno,years)
BEGIN
IF INSERTED.deptno <> @deptno_d AND INSERTED.deptno <> NULL OR INSERTED.years < 16 OR INSERTED.years > 60
BEGIN
RAISERROR ('插入的数据不符合格式')
ROLLBACK TRANSACTION
END
END