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對(duì)collect進(jìn)行insert操作后，book表里的數(shù)據(jù)并沒有發(fā)生改變是什么情況
請(qǐng)問sql server觸發(fā)器沒作用怎么辦？
繁花不似錦
2018-06-19 14:18:23
