IN and NOT IN
One of the most common mistakes made in T-SQL is thinking that these behave identically. I've personally opened up a...
2010-01-28
1,219 reads
One of the most common mistakes made in T-SQL is thinking that these behave identically. I've personally opened up a...
2010-01-28
1,219 reads
After a while, most people who work with SQL have accumulated quite a few scripts that they use for investigation,...
2010-01-20
510 reads
Overview
This is something that most people eventually need for reporting purposes. This function uses a Tally table to 'clean' a...
2010-01-13
4,188 reads
It seems like every blog I read has a list of goals posted for the year. This seems like a...
2010-01-09
333 reads
I see charindex used quite commonly in string manipulation. What I rarely see used is the optional third parameter. Here...
2009-12-21
2,926 reads
I see charindex used quite commonly in string manipulation. What I rarely see used is the optional third parameter. Here...
2009-12-19
4,198 reads
Tally (or numbers) tables are one of my favorite query writing tools. Such a simple premise that can be applied...
2009-12-17
3,185 reads
Tally (or numbers) tables are one of my favorite query writing tools. Such a simple premise that can be applied...
2009-12-14
3,020 reads
By Steve Jones
I love Chicago. I went to visit three times in 2023: a Redgate event,...
By Brian Kelley
I have found that non-functional requirements (NFRs) can be hard to define for a...
You can find the slidedeck for my Techorama session “Microsoft Fabric for Dummies” on...
Hi, I have SQL Server 2019 installed and when go the Clear Trace database...
Hello I need to get txt files from directory and send email, when I...
Hello, I have a question regarding Availability group server architecture. A little background: We...
Let’s consider the following script that can be executed without any error on both SQL Sever and PostgreSQL. We define the table t1 in which we insert three records:
create table t1 (id int primary key, city varchar(50)); insert into t1 values (1, 'Rome'), (2, 'New York'), (3, NULL);If we execute the following query, how will the records be sorted in both environments?
select city from t1 order by city;See possible answers