Using Triggers In MS SQL Server

(Page 1 of 4 )

Triggers allow us to execute a batch of SQL code when either an insert, update or delete command is executed against a specific table. In this article David will describe exactly what triggers are, he will show you how to create new triggers from scratch, how to test triggers, and also provide you with some valuable links/books to help you learn more about triggers.Designing a database for a large-scale web application is a monstrous task to say the least. It can however, be made easier by taking full advantage of the many tools, utilities and built-in objects that come with a Relational Database Management System (RDBMS), such as Microsoft SQL Server 7/2000.

One of these objects that many developers overlook is the trigger. Triggers are "attached" to a table and allow us to setup our database in such a way that whenever a record is added, updated, or deleted from a table, then SQL server will automatically execute a batch of SQL code after that table modification takes place.

We can do some really powerful things with the help of triggers. In this article I will describe exactly what triggers are, show you how to create new triggers from scratch, how to test those triggers, and also provide you with some valuable links/books to learn more about triggers.

To play around with the code in this article, you will need access to a computer running Microsoft SQL Server 7/2000. You should also be familiar with the structured query language (SQL). If you don’t have SQL Server, you can download a 120-day evaluation copy from http://www.microsoft.com/sql/downloads/default.asp.

Next: What exactly is a trigger? >>
 

More SQL Server Articles
More By David Rusik

Comments On: Using Triggers In MS SQL Server

· >> When this is the case, the "UPDATE" trigger is called for each row that was>>...    · Its really very helpfull for the beginners to learn it    · >> When this is the case, the "UPDATE" trigger is called for each row that was>>...    · >> When this is the case, the "UPDATE" trigger is called for each row that was >>...    · i have faced the same problem where i get an error which says multiple rows selected...    · its very helpful    · Very helpful for new ppl learning sql serverThanks,    · A)once triggers are called after specific times of insert command executions of...   >>> Post your comment now!