TRIGGER ISSUE!!用instead of insert 限制插入的某项数据为0以下的内容!

[tata_1980]

用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,那么这时该如何处理呢?

[aierong]

Create Trigger trigger_0count
On play_Table
for Insert
As
If (select 次数 from inserted) <=0
Begin
Print 'you cannot insert '
RollBack
End

[zjcxc]

按照你的意思,可以直接用下面的触发器:

Create Trigger trigger_0count
On play_Table
for Insert --这样记录还没有被插入,可以回滚
As
If exists(select 1from inserted whre 次数<=0)
Begin
Print 'you cannot insert record with count 0' --当然,这句不会有意义
RollBack tran
End

[zjcxc]

如果一定要用instead of触发器,可以这样写:
Create Trigger trigger_0count
On play_Table
for INSTEAD OF Insert
As
If exists(select 1from inserted whre 次数<=0)
Print 'you cannot insert record with count 0' --当然,这句不会有意义
else
insert into play_Table select * from inserted