Luiz Barros

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...

Visit the forum

Question of the Day

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

Luiz Barros

Testing all procs before upgrading to Compatibility Level 90

Find and Replace a String in the Whole Database

Change column type on constrained columns

Blogs

Convert SQL Audit Files to a CSV Using Read-SqlXEvent

Control Flow Restartability in Azure Data Factory

Monday Monitor Tips: Knowing Your RPO

Forums

changing over to a tab delimited file in my pkg that walks thru folders

how to query that stores mulit select field data

Getting all ancestral parents of a table

Question of the Day

STRING_AGG's behavior