Blogs

Modifying a Trigger to Capture More Info: #SQLNewBlogger

By

I had someone ask me about using triggers to detect changes in their tables....

From SQL Server to PostgreSQL: A Story of 5 Key SQL Differences

By

After spending decades working in SQL Server, getting familiar with PostgreSQL felt like traveling...

T-SQL Tuesday #187–Solving Problems

By

This month we have a great invite from Joe Fleming, a first time host...

Read the latest Blogs

Forums

Transitioning AlwaysOn Availability Group to Synchronous Commit Mode

By abdalah.mehdoini

Hello, I have a SQL Server with an AlwaysOn configuration consisting of three replicas...

CDC & Azure Managed Instances - Performance degredation

By Ant-Green

Anyone got any good advice for performance tuning CDC on a Managed Instance? We...

The Trigger Updated Column(s)

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Trigger Updated Column(s)

Visit the forum

Question of the Day

The Trigger Updated Column(s)

In a trigger, I can use UPDATE() or UPDATED_COLUMNS() to determine which columns were changed. For these functions, which one accepts a column name as a parameter?

See possible answers