Presenting at SQL Saturday #111
On Saturday, April 14, 2012, I’ll be presenting “Table Vars and Temp Tables – What you NEED to know!” at SQL...
2012-03-28
703 reads
On Saturday, April 14, 2012, I’ll be presenting “Table Vars and Temp Tables – What you NEED to know!” at SQL...
2012-03-28
703 reads
SQL Server 2012 introduces several new date/time functions that allow you to build a date/time from the individual parts of...
2012-03-15
2,927 reads
This month, Argenis Fernandez (blog, @DBArgenis) is hosting our monthly T-SQL Tuesday, and he wants to know: Are you specialized?...
2012-03-13
942 reads
On Saturday, March 10, 2012, I’ll be presenting “Table Vars and Temp Tables – What you NEED to know!” at SQL...
2012-02-28
1,399 reads
Table-Valued Functions. What a wonderful addition to SQL they make. They take parameters, do some work, and return a result...
2012-02-15
80,876 reads
I’m honored to have been selected to present two sessions at SQL Saturday #96 in our nation’s capital, Washington DC...
2011-11-02
784 reads
On Saturday, October 29, 2011 at 2:45 pm, I’ll be presenting “Table Vars and Temp Tables – What you NEED to...
2011-10-27
696 reads
Actually, I only submitted the winning entry; Denali CTP3 SQL Server 2012 is the real winner. After having a blog...
2011-10-26
805 reads
Recap of my first ever SQL PASS Summit – 2011:
Saturday, Oct 8 – Travel day – I flew from Richmond VA to the...
2011-10-17
1,455 reads
There is something wrong in the SQL force today… here it is the first Tuesday of a month, and we’re...
2011-10-04
793 reads
I realized I never created a post to show how to deploy Terraform from...
By Steve Jones
I’m late to the party this month. Taiob Ali has a great invite for...
This month’s TSQL Tuesday invite is from my good friend, long standing MVP and...
Comments posted to this topic are about the item Building a Database Dashboard with...
Good morning, I've noticed my CDC job running for 17 days. I've noticed it...
We have recently upgraded from SQL Server 2016 to 2022 Standard Edition. Our nightly...
I am creating a trigger in SQL Server 2022 and want to detect a change in a table. Here is my table DDL:
CREATE TABLE CustomerLarge ( CustomerID INT NOT NULL IDENTITY(1,1) CONSTRAINT CustomerLargePK PRIMARY KEY CLUSTERED , CustomerName VARCHAR(20) , CustomerContactFirstName VARCHAR(40) , CustomerContactLastName VARCHAR(40) , Address VARCHAR(20) , Address2 VARCHAR(20) , City VARCHAR(20) , CountryCode CHAR(3) , Postal VARCHAR(20) , creditlimit INT , discount numeric(4,2) , lastorderdate DATETIME , lastorderamount NUMERIC(10,2) , lastordercontact VARCHAR(20) , created DATETIME , modified DATETIME , modifiedby VARCHAR(20) , statusid INT , active BIT , customersize INT , primarysalesid INT) GOIf I want to detect that the creditlimit was updated, what IF statements should I use? See possible answers