ALTER trigger [dbo].[insert_collect]on [dbo].[collect]for insertasbegindeclare @bno charselect @bno from insertedupdate dbo.book set dbo.book.bcollect =dbo.book.bcollect +1 where @bno=dbo.book.bnoend對collect進行insert操作后,book表里的數據并沒有發生改變是什么情況
請問sql server觸發器沒作用怎么辦?
繁花不似錦
2018-06-19 14:18:23