Last month I wrote a post titled Broken Left Join which covered an easy to make mistake that I see fairly regularly when reviewing code. This month I’m covering UPDATE statements that run into trouble because of JOINs. Updates with joins are not covered by the ANSI standard. To see the problems that can occur with […]
Hi, I'm James Anderson. When I'm not blogging about SQL Server, I do this.