An AFTER INSERT trigger may not work correctly after you apply the fix documented in 975950 posted on Mär 22, 2011 von Frank Kalis in Links
Don’t depend on expression short circuiting in T-SQL (not even with CASE) posted on Mär 4, 2011 von Frank Kalis in Links
How to remove duplicate rows from a table in SQL Server posted on Feb 20, 2011 von Frank Kalis in Links