Retrieving Identities on set-based inserts
Learn a foolproof way to get identity values for multi-row inserts with the OUTPUT clause in SQL Server 2005 without using a cursor.
2010-01-20
4,369 reads
Learn a foolproof way to get identity values for multi-row inserts with the OUTPUT clause in SQL Server 2005 without using a cursor.
2010-01-20
4,369 reads
Tips on parsing and sculpting XML from within a SQL 2005 stored procedure
2009-10-19
10,265 reads
2009-10-05 (first published: 2009-09-21)
2,177 reads
By Steve Jones
Today’s coping tip is to focus on what’s good, even if today feels tough....
By Steve Jones
SQL Data Compare (SDC) is a great way to sync data among tables. It’s...
By Steve Jones
Today’s coping tip is to be gentle with yourself when you make mistakes. I...
I have a two-replica SQL Server Availability Group running on Windows VMs in the...
I have a SQL agent job which starts the trace (for audit purpose) everyday...
I have a number of databases on a sql server 2017 instance. For most...