TRIGGER ISSUE!!用instead of insert 限制插入的某项数据为0以下的内容!
用after insert写的:
Create Trigger trigger_0count
On play_Table
After Insert
As
If (select 次数 from inserted) <=0
Begin
Print 'you cannot insert record with count 0'
RollBack
End
Set Nocount On
-----------------------
但我想用instead of触发器,
请问,对应上面 RollBack的那项,该如何填写呢?这时这个记录还没有插入,应该用不上rollback,那么这时该如何处理呢?