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,521 reads

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.


1,538 reads


Getting the Proc Code–#SQLNewBlogger


Another post for me that is simple and hopefully serves as an example for...

Running SQL Server in Google Cloud Platform


On a few occasions I’ve referred to GCP (Google Cloud Platform) as the “Windows...

More ADLS Gen2 enhancements


On the heels of More Azure Blob Storage enhancements come more enhancements for Azure...

Read the latest Blogs


Memory-Optimized Table Truncation

By Evgeny Garaev

Comments posted to this topic are about the item Memory-Optimized Table Truncation

A Digital Wish Card for Ken

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Digital Wish Card for...

Business Reasons For Implementing Power BI

By Brandon Forest

Comments posted to this topic are about the item Business Reasons For Implementing Power...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers