2014-07-07
2,137 reads
Chris Nowicki
Random problems
Building random numbers can be challenging for people working in T-SQL. New author Chris Nowicki brings a solution he used to get a random number assigned to each row of a result set.
2009-06-09
5,076 reads
Blogs
Spark Connect Dotnet Variant Data Type
By Ed Elliott
All Spark Connect Posts I recently published the latest version of the Spark Connect Dotnet...
A New Word: Opia
By Steve Jones
opia – n. the ambiguous intensity of eye contact The entry for this says...
Friday Flyway Tips: Searching a Migration
By Steve Jones
This was actually a cool tip I saw internally from one of the product...
Forums
Table Partitioning SQL server 2022
Hi All, I am currently testing the Table Partitioning to implement in SQL server...
STRING_AGG's behavior
Comments posted to this topic are about the item STRING_AGG's behavior
The Role of Databases in the Era of AI
Comments posted to this topic are about the item The Role of Databases in...
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;