Unexpected result with the File System Task
Recently I ran across a forum thread where someone encountered an unexpected result when creating a directory using the File...
2013-10-09
631 reads
Recently I ran across a forum thread where someone encountered an unexpected result when creating a directory using the File...
2013-10-09
631 reads
After over 6 months of silence, it is time again for another Stupid me™®©! For those unfamiliar with the concept:
Every...
2013-10-01
638 reads
After over 6 months of silence, it is time again for another Stupid me™®©! For those unfamiliar with the concept:
Every...
2013-10-01
351 reads
It’s the second Tuesday of the month, and you know what time it is! That’s right, another installment of T-SQL...
2013-09-10
434 reads
It’s the second Tuesday of the month, and you know what time it is! That’s right, another installment of T-SQL...
2013-09-10
784 reads
With the release of the revamped Integration Services in SQL Server 2012, a bunch of new deployment methods were introduced...
2013-08-21
7,548 reads
This article describes different methods for deploying your SSIS projects to a server.
2013-08-15
9,858 reads
The site connect.microsoft.com is a wonderful concept: you can provide feedback about the Microsoft products, report bugs and give suggestions...
2013-07-29
706 reads
2013-07-19
2,679 reads
To prepare myself for my session Data Visualization Tips & Tricks, I read a few books. In this blog post, I’ll...
2013-07-16
1,086 reads
By Kevin3NF
Can we normalize a couple of things? 1 – Trade Schools. Back in the...
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...
hi we run 2019 std. we saw this week that someone hid 3 important...
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?
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