The Non-Cluttered Index

It seems we can’t find what you’re looking for. Perhaps searching can help.

Blogs

Why DBAs Still Need to Know the Foundations of SQL Server

By

Over the years, I’ll admit, SQL Server has come a long way in making...

Data Saturday Columbus 2025 Recap

By

This weekend was one of my favorite Data Saturday events, Data Saturday Columbus! If...

Cosmos DB vs Traditional SQL: When to Choose What

By

From where I stand, the decision between Cosmos DB and a traditional SQL database...

Read the latest Blogs

Forums

Considering READPAST Hint for DELETE Operations – Lock Contention Analysis

By abdalah.mehdoini

Salut l'équipe, Lors de l'exécution parallèle d'opérations DELETE sur la table [YourTableName], j'ai observé...

Can You Ask for a Raise?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Can You Ask for a...

A Big Updated Columns List

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Big Updated Columns List

Visit the forum

Question of the Day

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

See possible answers