Steve McRoberts

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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(35)

You rated this post out of 5. Change rating

2010-01-20

4,587 reads

Tips on parsing and sculpting XML from within a SQL 2005 stored procedure

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(24)

You rated this post out of 5. Change rating

2009-10-19

10,375 reads

If you are considering any of the ISACA AI certs like the Advanced Artificial...

Are you currently using Microsoft Fabric or considering migrating to it? If so, there...

Track SQL Server Configuration Changes Using the Error Log If you...

Comments posted to this topic are about the item We Are Eating Our Own...

Artificial intelligence tools are quickly becoming part of daily business operations, from document analysis...

Comments posted to this topic are about the item Designing SQL Server ETL Pipelines...

In the Database Engine, when a deadlock is detected, what does the detection interval shrink to (in time)?