With this project I needed to insert data into table1 from table2 while simultaneously retrieving the identity field of table1, then insert that identity into table3 which mapped to table2 on a key that table1 did not have. The OUTPUT clause when used with the input statment would not facilitate this because it could not [...]
Archive of posts filed under the SQL Server 2008 category.
Using the Merge Statement’s OUTPUT Clause to Match Inserted IDENTITY Fields with Source Table Fields
SQL Server Slow Performance
This pose deals with a random hanging that sometimes happens with SQL Server 2005+. In order to troubleshoot SQL Server Slowness, go here. The introduction of the new SQL Server 2005 Query Optimization engine has brought great things (including statement-level caching and smarter execution plan generation). There is however a little more overhead with the [...]
