SQLStudies

Blog Post

fn_OBJECT_TYPE

I recently started using OBJECT_NAME, OBJECT_SCHEMA_NAME and OBJECT_ID functions; unfortunately I really could have used OBJECT_TYPE but it doesn’t exist...

2012-10-19

1,234 reads

Blog Post

Multiple CTEs

Multiple CTEs
It’s somewhat obscure in BOL and I wasn’t able to find any examples but it turns out you can...

2012-10-11 (first published: )

4,561 reads

Blogs

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

Why Microsoft Fabric Signals the Next Wave of Data Strategy

By

In today’s data-driven economy, organizations are no longer asking if they should invest in...

PostgreSQL Timeline: History and Evolution

By

PostgreSQL, often referred to as Postgres, is a powerful, open-source object-relational database system that...

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

Databases and Disasters

By Grant Fritchey

Comments posted to this topic are about the item Databases and Disasters

Automating SQL Server Access Review

By Deepam Ghosh

Comments posted to this topic are about the item Automating SQL Server Access Review

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