Transaction and Local Variables - Swap Variables - Update All At Once (blog.sqlauthority.com)
submitted by
pinaldave(9662) 3 years, 7 months ago
Summary : Transaction have no effect over memory variables. When UPDATE statement is applied over any table (physical or memory) all the updates are applied at one time together when the statement is committed.
|category: Database
|Views: 14
tags:
SQLAuthority SQL2K8 pinaldave Database SQLServer another
Everyones tags:
Your Tags: