Ed Elliott's Sql Developer Blog

Blogs

Article: SQL Server Sample Databases

By

herefore, from Northwind and pubs to WideWorldImporters, I've compiled where to get those databases...

PostgreSQL 17: A Deep Dive into New Features, Benefits, and Enterprise Impact

By

PostgreSQL 17 introduces a new era of innovation in open-source database technology. This release...

The Evolution of Data: From Databases to Spark to Lakebases

By

The circle cylinder of life Maybe you’ve noticed all the twenty somethings tight rolling...

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...

Unlocking Interoperability: A Guide to Foreign Data Wrappers in PostgreSQL and Aurora PostgreSQL AWS RDS

By Arvind Toorpu

Comments posted to this topic are about the item Unlocking Interoperability: A Guide to...

Disaster Recovery for Azure SQL

By sqlgigs

I am creating a Disaster Recovery plan for Below Data pipeline. I need to...

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