By tag: TableVariables
0
kicks
Biggest difference between Temp tables and Table variables in Sql Serv
One of the most important differences between Temp tables and Table variables is how they behave in transactions. See how.
0
kicks
SQL Server: How to audit rollback-ed data in a trigger?
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...