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,348 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,262 reads
2009-10-05 (first published: 2009-09-21)
2,152 reads
Blogs
Being a script magpie
Last month (I ran just a little bit late writing this, it was meant...
Community Tools Month 2022 - dbatools
By alevyinroc
The Prompt In July, Brent Ozar (blog | twitter) asked us to make September...
Storytelling with Data – Enertia User Conference 2022
By DataOnWheels
Thank you to everyone who attended my session at the Enertia User Conference in...
Forums
Missing weekend data to Zero
Hi All, I have a requirement that if there is no weekend data then...
Alight Motion is safe for users?
Description: Alight Motion edits application that allows you to edit videos in the Android smartphone....
How to calculate orders historically, during month
Good Morning There, CREATE TABLE Customers ( CID int NOT NULL PRIMARY KEY, GroupName...
Ask SSC