Steve Hood

From this link - https://stackoverflow.com/questions/22005698/how-to-find-all-the-dependencies-of-a-table-in-sql-server I can find all the child dependencies starting from my...

Something Odd About CAST/TRY_CAST

By Chris Wooding

I've got some code that is supposed to generate a unique key by prefixing...

Visit the forum

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;
GO

What 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;

See possible answers