T-SQL Tuesday 89 - The times they are a changing!
T-SQL Tuesday is a monthly blog party for the SQL Server community (or Microsoft Data Platform community. Although it’s called...
2017-04-11
370 reads
T-SQL Tuesday is a monthly blog party for the SQL Server community (or Microsoft Data Platform community. Although it’s called...
2017-04-11
370 reads
If you are a SQL Server professional and are interested in spending a day with a bunch of other like-minded...
2017-03-27
303 reads
Another great teaching opportunity landed in my lap this week. I got an email from a coworker looking for some...
2017-03-09 (first published: 2017-03-01)
2,659 reads
Another great teaching opportunity landed in my lap this week. I got an email from a coworker looking for some...
2017-03-08
432 reads
2017-03-03
Just wanted to put a quick post out there for the people who follow me. I very recently made a...
2017-03-03
338 reads
This is something that has caused me some grief in my life as a DBA. I hesitate to call it...
2017-02-08 (first published: 2017-02-03)
8,316 reads
This is something that has caused me some grief in my life as a DBA. I hesitate to call it...
2017-02-03
349 reads
Shout out to Kenneth Fisher (b|t) for hosting this month's #tsql2sday. This month is about backup and recovery and here...
2016-12-13
400 reads
Shout out to Kenneth Fisher (b|t) for hosting this month's #tsql2sday. This month is about backup and recovery and here...
2016-12-13
264 reads
Data isn't just about numbers and spreadsheets. It holds stories, patterns, and the answers...
By Brian Kelley
When I look at a system and think about its security model, the first...
On Wednesday May 15th 2024 I will give a free webinar on MSSQLTips.com about...
Comments posted to this topic are about the item The "ORDER BY" clause behavior
Comments posted to this topic are about the item Are IT Certifications Still Relevant?
I have table TicketNumbers i TicketNumber UID 2 10 09901a22c7c3acc6786847c775f1d113 6 5 00dad28bef21f916240d6e8c1c1bd67d 12 ...
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