阅读背景:

如何在SQL Server触发器中测试多行操作?

来源:互联网 

My kindergarten SQL Server taught me that a trigger may be fired with multiple rows in the inserted and deleted pseudo tables. I mostly write my trigger code with this in mind, often resulting in some cursor based cludge. Now I'm really only able to test them firing for a single row at a time. How can I generate a multirow trigger and will SQL Server actually ever send a multirow trigger? Can I set a flag so that SQL Server will only fire single row triggers??My kindergarten SQL Server taught me that a tri




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: