我刚创造了一个After After Trigger,语法如下: - A# S9 z: f5 zCreate trigger tgrInsteadTrigger on copytabletoInstead of Insert as Declare @store_name varchar(30); declare @sales int; declare @date datetime; select @store_name = i.store_name from inserted i select @sales = i.sales from inserted i select @date = i.Date from inserted ibegin if (@sales > begin RAISERROR('Cannot Insert where salary > ROLLBACK; end else begin insert into copytablefrom(store_name,sales,date) values (@store_name,@sales,@date); Print 'Instead After Trigger Executed endEnd在上述语法中,我使用了 RAISERROR('Cannot Insert where salary > 1000',16,1) 2 }) }) E$ \9 }% j" W4 h但是当我写RAISERROR('Cannot Insert where salary >1000')它在同一行上犯了错误’)’附近的语法不正确。0 y- \& w$ G }) l C
任何人都可以在这里解释(16、1)的用法。4 V' [ U. M% @