By tag: TableVariables
Ban this user: Options
Please provide a reason for deleting this story
One of the most important differences between Temp tables and Table variables is how they behave in transactions. See how.
The most popular method of auditing data is with an AFTER DELETE, INSERT, UPDATE trigger. But what happens if you have a Rollback statement in your trigger if some condition is met? <br><br> More ><a href="http://weblogs.sqlteam.com/mladenp/archive/2007/04/13/60174.aspx&q...