Triggers

SQLServerCentral Article

Row-By-Row Processing Without Cursor

  • Article

If you are a SQL Server DBA, you realize that the performance of cursors is not great and they should be avoided where possible. One place it is difficult to avoid cursors is individual row processing within a trigger. Amin Sobati brings us a new article that shows just how you can avoid this.

2.88 (93)

You rated this post out of 5. Change rating

2007-12-28 (first published: )

47,830 reads

Technical Article

Using DDL Database Triggers

  • Article

In this short demonstration, you'll learn how to use DDL database triggers to prevent changes to product and audit changes to comply with Sarbanes-Oxley and other change management requirements. Free registration required.

2006-07-20

3,395 reads

SQLServerCentral Article

Worst Practice - Triggering External Events

  • Article

Andy Warren started his worst practice series some time ago with the intention of looking at the worst things you can do. Given that we may not always be able to implement the best practices, at least we can try to avoid doing things harm the system or decrease performance. This article continues the series and looks at an item I see mentioned in our discussion forum quite often, triggering external events. From a trigger.

You rated this post out of 5. Change rating

2004-02-23

10,228 reads

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)

You rated this post out of 5. Change rating

2003-11-24

12,430 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)

You rated this post out of 5. Change rating

2003-08-21

18,160 reads

SQLServerCentral Article

Triggers in SQL Server 7.0 and 2000 - What's New

  • Article

This is the second of a two part series on how triggers work in the two latest versions of MS SQL Server. The first part dealt with what is common between the two versions. This article will detail what's been added to SQL Server 2000.

4 (1)

You rated this post out of 5. Change rating

2005-06-24 (first published: )

72,958 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)

You rated this post out of 5. Change rating

2005-01-21 (first published: )

110,844 reads

Blogs

My 2024 in Data: Music

By

This is my last week of the year working (I guess I come back...

A New Word: Suente

By

suente– n. the state of being so familiar with someone that you can be...

Side Projects

By

Anyone (everyone?) who has ever tried to learn a programming language knows that to...

Read the latest Blogs

Forums

Timeout Error while executing a TSQL statement in Sql server Express Edition

By IT researcher

I am getting the below error when I execute a SQL command in SQL...

Timeout Error while executing a TSQL statement in Sql server Express Edition

By IT researcher

I am getting the below error when I execute a SQL command in SQL...

Sql script replace and rearrange numbers

By diegodeveloper

Hi everyone. I have this table and this information. (left side of the image)...

Visit the forum

Question of the Day

DCL

We have DDL, DML, and DCL. What is DCL used for?

See possible answers