News From EAP Testing
Jonathan Allen takes a peak at the EAP release of SQL Prompt 6 and some of the cool new things you can do to speed up writing SQL.
2013-08-21
1,637 reads
SQL PROMPT
SQL Prompt Tips #2 - Casing Options
A quick tip to help you set your object names to your preferred case in T-SQL code.
2015-10-21 (first published: 2012-05-01)
2,206 reads
SQL Prompt Tips #4 - System Objects
A quick tip to help you get system object suggestions from SQL Prompt.
2015-11-04 (first published: 2012-05-01)
1,233 reads
SQL Prompt Tips #3 - Snippet Placeholder $Paste$
Another quick tip for SQL Prompt, using the snippets to increase your productivity.
2015-10-28 (first published: 2012-05-01)
1,471 reads
SQL Prompt Tips #1 - Selecting in the Object Explorer
A quick tip to help you get the most out of SQL Prompt.
2015-10-14 (first published: 2012-05-01)
1,645 reads
SQL Server Intellisense VS. Red Gate SQL Prompt
Fabiano Amorim is hooked on today's Integrated Development Environments with built-in Intellisense, so he looked forward keenly to SQL Server 2008's native intellisense. He was disappointed at how it turned out, so turned instead to SQL Prompt. Fabiano explains why he prefers to SQL Prompt, why he reckons it fits in with the way that database developers work, and goes on to describe some of the features he'd like to see in it
2010-04-09
4,030 reads
Blogs
Monday Monitor Tips: Knowing Your RPO
By Steve Jones
A customer was asking recently about the RPO for their estate, and I showed...
Webinar tomorrow: The Role of Databases in the Era of AI
By Steve Jones
I’m hosting a webinar tomorrow with Rie Merritt from Microsoft. We’ll be talking about...
Spark Connect Dotnet Variant Data Type
By Ed Elliott
All Spark Connect Posts I recently published the latest version of the Spark Connect Dotnet...
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;