Testing for an Updated Column in a Trigger

The columns_updated function gives you the ability to easily test to see if specific columns were modified with less code than you might otherwise need to use. In this article Andy Warren demonstrates how to create a trigger that uses this function and points out some reasons why you may NOT want to use it!

4 (3)


17,915 reads


2020 Advent of Code–Day 1


This series looks at the Advent of Code challenges. I started the Advent of...

Server Review Essentials for Accidental and Junior DBAs—Setting Up (Part 2)


Welcome back to my Server Review Essentials for Accidental and Junior DBAs series. Last...

One Chart at A Time Video Series


Jon Schwabish over at PolicyViz has created great initiative called the One Chart at...

Read the latest Blogs


Interesting bug in SQL 2016 CHOOSE

By ScottPletcher

While trying, in SQL 2016 (13.0.5850.14), to see if CHOOSE allowed an inline query...

SSIS jobs

By sqlguru

I have always run the SSIS package using SQL Agent jobs. However, I am...

String Shrinking

By Steve Jones - SSC Editor

Comments posted to this topic are about the item String Shrinking

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers