Coding Family

Coffee poured into a mug

Weekly reading #30

Good morning in November! We were all looking at the Microsoft Ignite in Orlando last week. And it happened! SQL Server 2019 is now generally available – more details...

2019-11-11

35 reads

Weekly reading #30

Good morning in November! We were all looking at the Microsoft Ignite in Orlando last week. And it happened! SQL Server 2019 is now generally available – more details...

2019-11-11

4 reads

Coffee and Granules

Weekly reading #29

The Data Breach Game: The 9 Worst IT Security Practices Joey D’Antoni shows bad practices for security in SQL Server. He summarizes all the most important areas you should...

2019-10-21

20 reads

Weekly reading #29

The Data Breach Game: The 9 Worst IT Security Practices Joey D’Antoni shows bad practices for security in SQL Server. He summarizes all the most important areas you should...

2019-10-21

2 reads

Image

Interview with Bob Ward

This is the eight interview we have done. This time our guest is the one and the only Bob Ward! Bob Ward is a Principal Architect for the Microsoft...

2019-10-30 (first published: )

368 reads

Coffee

Weekly reading #28

September is over. This was not a good month for us. We had to cancel the conferences planned for September and were not able to write as much as...

2019-10-10

25 reads

Weekly reading #28

September is over. This was not a good month for us. We had to cancel the conferences planned for September and were not able to write as much as...

2019-10-10

1 reads

Blogs

Understanding Zonal Redundancy in Azure SQL MI

By

Do you know what happens when you enable zonal redundancy for your SQL managed...

SQL Server Database Compatibility Levels

By

Why You Shouldn’t Overlook This Quiet but Critical SQL Server Setting   If you’ve...

The PASS Summit on Tour in the Netherlands

By

The PASS Summit goes on tour this year, with the final date the first...

Read the latest Blogs

Forums

How a Legacy Logic Choked SQL Server in a 30-Year-Old Factory

By Chandan Shukla

Comments posted to this topic are about the item How a Legacy Logic Choked...

How do I make this one row per id

By ajillity81

I've written this code, but it is showing right now as 2 rows per...

Getting In: Running External Code in a Locked-Down PaaS

By Tonie Huizer

Comments posted to this topic are about the item Getting In: Running External Code...

Visit the forum

Question of the Day

The Updated Columns List

I have this table in SQL Server 2022:

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)
)
GO
If I check the columns_updated() function return in a trigger, what is the data returned?

See possible answers