How do you create or update stored procedures.
G’day,
Running object creation scripts into other environments is a big part of most DBA’s work – especially when a new system...
2011-05-04
17,826 reads
G’day,
Running object creation scripts into other environments is a big part of most DBA’s work – especially when a new system...
2011-05-04
17,826 reads
Advertisements
Meme Monday: I Got 99 SQL Problems and the Disk Ain’t One
I am a bit late to this party. I have seen...
2011-05-04
464 reads
Today is the last day to submit session abstracts for the PASS 2011 Summit. I was lucky enough to speak...
2011-05-04
474 reads
This post is based on an interesting question/situation that was posted over at ASKSSC.com today. The user asked how to...
2011-05-04
1,387 reads
Hopefully if you came to my session this year at SQL Saturday in Jacksonville, FL you came away with some...
2011-05-04
503 reads
Ed Wilson (Blog|Twitter) aka Scripting Guy has series of SQL Server related posts the week of May 2nd 2011 including...
2011-05-04
822 reads
SQLRally is a week away. Are you ready? It’s going to be a good time to learn and freshen up...
2011-05-04
477 reads
I see this issue pop up every now and then: A developer creates an SSIS package in BIDS and gets...
2011-05-04
788 reads
In January 2009, I made the transition back to being a senior DBA. One of the first things my manager...
2011-05-04
2,927 reads
Amazingly It’s been just over 4 months since I started my list of UK based SQL Server bloggers, and I...
2011-05-03
594 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