If you fire that trigger, make sure you have the correct ID
G’day,
I think it would be a fair bet to say that we’ve all used the @@IDENTITY function. It returns the...
2011-04-02
565 reads
G’day,
I think it would be a fair bet to say that we’ve all used the @@IDENTITY function. It returns the...
2011-04-02
565 reads
Day 2 Introduction to Windows Powershell. Windows Powershell is a very powerful shell script to interact with windows. Using windows...
2011-04-02
1,463 reads
I had the opportunity to present my “What Can You Do With PowerShell?” session in Dallas at SQL Saturday #63....
2011-04-02
636 reads
So,
I actually had a early morning sessions and gave my Solid State Storage talk and had a great time. The audience was...
2011-04-02
631 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
The T-SQL LOWER() command allows you to change an uppercase string to a lowercase string.
For example, it will allow you to change the word...
2011-04-02
851 reads
I joked about having a 22 hour layover in Denver yesterday and a few people were wondering what airline screwed...
2011-04-01
841 reads
Recently there have been a number of PASS members who have become unhappy with the direction of the organization and...
2011-04-01
390 reads
As DBAs, we are responsible for the protection of our organization’s data, and we have many different options to protect...
2011-04-01
591 reads
I See Dead Tech….
Knowing when a technology is dying is always a good skill to have. Like most of my...
2011-04-01
911 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...
By Kevin3NF
Can we normalize a couple of things? 1 – Trade Schools. Back in the...
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