Watch this week's video on YouTube
I write a lot of dynamic SQL and frequently encounter variables that contain many characters:
DECLARE @LongValue NVARCHAR(MAX) = CAST('' AS NVARCHAR(MAX)) +
N'SELECT
...
2018-08-07
11 reads
Click here to watch this week’s video on YouTube.
I write a lot of dynamic SQL and frequently encounter variables that...
2018-08-07
384 reads
“I am a new user of SQL Server so I have very limited knowledge of its features. I would like...
2018-08-07
1,190 reads
“I am a new user of SQL Server so I have very limited knowledge of its features. I would like to know how to generate script with data of...
2018-08-07
26 reads
2018-08-07
54 reads
In this module you will learn how to use the Small Multiple Line Chart. The Small Multiple Line Chart allows...
2018-08-07 (first published: 2018-07-31)
2,283 reads
Last week’s quiz was on Table Value Constructors in TSQL. Essentially, table value constructors let you create a dataset on the fly. These can occasionally be useful in writing...
2018-08-07
45 reads
It’s time for another T-SQL Tuesday. The brainchild of Adam Machanic (b|l|t), and designed to strengthen the SQL Server blogging...
2018-08-07
349 reads
I thought I’d give you all a little preview of our latest offering, the Undercover Catalogue which should be available...
2018-08-06
271 reads
Come see my presentation on Machine Learning Server for SQL Server at SQL Saturday Denver
2018-08-06
21 reads
I’m excited to announce the release of a new open-source project that fully automates...
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Comments posted to this topic are about the item Optional Parameter Plan Optimization in...
Comments posted to this topic are about the item AI Experience Gap that we...
There is a table tmp_tab:
CREATE TABLE tmp_tab ( id int, val int );
INSERT INTO tmp_tab VALUES (1, 1), (2, NULL), (3, 3), (4, 4), (5, 5);You want to order the rows ids by the following expression:
ISNULL(val, id) + 1Which of the following queries produces the expected ordering and why? (Select all correct) See possible answers