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,493 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,329 reads
Blogs
Convert SQL Audit Files to a CSV Using Read-SqlXEvent
By Patrick
SQL Server Audit is an efficient way to track and log events that occur...
Control Flow Restartability in Azure Data Factory
I presented at SQL Saturday Pittshburgh this past weekend about populating your data warehouse...
Monday Monitor Tips: Knowing Your RPO
By Steve Jones
A customer was asking recently about the RPO for their estate, and I showed...
Forums
Wrong frames in blocked process report
Hi all, I'm on a sql server 2019 standard edition (15.0.4375.4) where I've a...
SRSS Failed Setup " The System cannot find the file specified (0x80070002)
Dear All, I am facing issue when update my license SRSS 2022 from...
Git Repo(s) for SQL Server Database, SSIS, SSAS, SSRS, PowerBI
Hey all, Just wondering how do you guys / girls set up git repo(s)...
Question of the Day
STRING_AGG's behavior
Executing the following script (Sql Server 2022), you get the table t0 with 10 rows:
CREATE TABLE t0
( id INT PRIMARY KEY
, field1 VARCHAR(1000)
, field2 VARCHAR(MAX));
INSERT INTO t0
SELECT
gs.value
, REPLICATE ('X', 1000)
, REPLICATE ('Y', 1000)
FROM generate_series(1, 10, 1) gs;
GOWhat happens if you execute the following statements?
select STRING_AGG(field1, ';') within group (order by id) from t0;
select STRING_AGG(field2, ';') within group (order by id) from t0;