Triggers

SQLServerCentral Article

Bypassing Triggers

  • Article

This articles covers a variety of techniques to let you bypass or conditionally execute code in a trigger based on criteria outside of the inserted/deleted tables. It also includes a contest that gives you a chance to win a copy of our book The Best of SQLServerCentral.com 2002!

5 (5)

2003-11-24

11,929 reads

SQLServerCentral Article

Testing for an Updated Column in a Trigger

  • Article

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)

2003-08-21

17,945 reads

SQLServerCentral Article

Triggers in SQL Server 7.0 and 2000 - The Common Ground

  • Article

This is a two part series on how triggers work in the two latest versions of MS SQL Server. Because there are some pretty significant additions in trigger functionality from 7.0 to 2000, we'll first need to look at what the two versions have in common. The second part to this series will look at the differences between the two MS SQL Server versions.

4.4 (5)

2005-01-21 (first published: )

110,708 reads

External Article

SQL Server 2000: .NET and the Death and Re-Birth o

  • Article

In this month's article I will cover an aspect of SQL Server that always generates a great deal of, well, shall we say "discussion"—triggers. Love them or hate them, SQL Server 2000 will change they way you think about triggers and will probably alter the way you design your applications. Specifically, this month I will dive into cascading referential integrity (RI) and the new INSTEAD OF and AFTER trigger concepts in SQL Server 2000.

2001-07-27

1,538 reads

Blogs

Daily Coping 23 Sep 2022

By

Today’s coping tip is to notice what you are feeling without any judgment. Today...

Snowflake – Where is the explain/execution plan?

By

Whatever your database background is you will have heard of an execution / explain...

Daily Coping 22 Sep 2022

By

Today’s coping tip is to ask a trusted friend to tell you what strengths...

Read the latest Blogs

Forums

Unable to Connect to Report Server

By bruce

Hello, I am currently unable to connect to my report server that I use...

find deprecated or reserved keywords in SQL Script.

By DBA

Hello, How to catch/find deprecated or reserved keywords being used in specific or single...

Access the SQL Server 2017 from Cloud Application

By kihastyga

Hi, Sorry if this looks a very basic question but I am bot getting...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers