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,255 reads
Steve McRoberts
Using XML to pass and return values to procs
Tips on parsing and sculpting XML from within a SQL 2005 stored procedure
2009-10-19
10,257 reads
2009-10-05 (first published: 2009-09-21)
2,096 reads
Blogs
Daily Coping 24 Sept 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Using environment variable files for SQL Server in containers
There are a whole bunch of environment variables that can be used to configure...
How to Design Backups in SQL Server?
By nelsonaloor
The Recovery Point Objective (RPO) and Recovery Time Objective (RTO) are basic concepts related...
Forums
Volunteer For Something
Comments posted to this topic are about the item Volunteer For Something
Linked Server location?
I have inherited a SQL Server that makes a call to a Linked Server...
Merge issue
I have a merge stored procedure that may be conflicting with the structure of...
Ask SSC