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表里的數(shù)據(jù)并沒有發(fā)生改變是什么情況
請問sql server觸發(fā)器沒作用怎么辦?
繁花不似錦
2018-06-19 14:18:23