SQL Table Columns Disappear in Access
A couple weeks ago a user complained that on one of our development databases, one of the views he was...
2011-09-28
1,589 reads
A couple weeks ago a user complained that on one of our development databases, one of the views he was...
2011-09-28
1,589 reads
Because this was a problem that Google was zero help on and I did find a couple other people afflicted...
2011-09-21
2,133 reads
This is a technique I’m sure many people are already using in their environments. Instead of using the actual name...
2011-09-14
3,590 reads
Here are a couple more SSMS tricks I’ve stumbled upon recently. Both involve the functionality of registered servers. If you...
2011-04-17
1,579 reads
This is one that I figured most everyone would know, but repeatedly over the past couple weeks in my office,...
2011-04-02
1,333 reads
Most of us like things that make our lives easier. When they’re free, it’s just that much sweeter. I would...
2011-02-13
1,567 reads
This isn’t exactly the best thing since bread (or even sliced bread for that matter), but I figured I’d share...
2011-02-07
1,297 reads
So… this is late. And I missed my q3 goals review all together. Oh well, not much I can do...
2011-01-23
719 reads
Last year I posted professional goals along with quite a few other bloggers and it helped to keep me somewhat...
2011-01-23
756 reads
So, after a rather hectic few months, I’m finally crawling back out of the hole I’ve been occupying and getting...
2010-09-16
733 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...
Testing with AG on Linux with Cluster=NONE. it was all going ok and as...
Hi, I have two tables: one for headers with 9 fields and another for...
We're trying to understand how quick new versions of SQL server can be. Obviously...
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