Southern New England SQL Server Users Group
Tomorrow, Wednesday April 14th, is the next SNESSUG meeting. We’re going to get a great presentation from Scott Abrants on...
2010-04-13
721 reads
Tomorrow, Wednesday April 14th, is the next SNESSUG meeting. We’re going to get a great presentation from Scott Abrants on...
2010-04-13
721 reads
Tomorrow is the Seacost SQL Server User’s Group inaugural meeting. I’ll be presenting a session called “Understanding Execution Plans.” It’s...
2010-04-12
730 reads
I’ve posted before about issues I’m having either with behaviors of nHibernate, or behaviors of teams using nHibernate, but I...
2010-04-09
961 reads
The kids over at the Professional Association of SQL Server Users have done it again. They’re hosting 24 Hours of...
2010-04-06
708 reads
One of the national sponsors for SQL Satuday is Confio Software. Just because they sponsor SQL Saturday, it’s worth checking out their...
2010-04-06
2,744 reads
I’ve blogged in the past about the nHibernate project that has been going on at my company for the last...
2010-04-05
1,006 reads
I received my renewal notice and, after checking the message header, it is April 1st, I got very happy. I’d...
2010-04-01
507 reads
New York, New York, it’s a hell of a town. The Bronx is up and the Battery’s down. The people...
2010-03-23
550 reads
One of my development teams needed a mechanism for identifying the value of a key that was part of a...
2010-03-18
4,660 reads
Aaron Bertrand showed up to teach us tips and tricks for SQL Server Management Studio. We had to move our...
2010-03-15
608 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