From the course: Complete Guide to Advanced SQL Server

Unlock the full course today

Join today to access over 24,400 courses taught by industry experts.

Create a trigger to print a message

Create a trigger to print a message - SQL Server Tutorial

From the course: Complete Guide to Advanced SQL Server

Start my 1-month free trial Buy for my team

Create a trigger to print a message

“

Using an AFTER trigger, we can return a custom message to the end user when new data is added into a table. To set this up, I'm going to make sure that I'm using the KinetEcoTRG database and we'll create a new table called dbo.Products. This table will have two different columns, one called productID and the other one called productName. And then, so that we can see what the default message window looks like before we add in a trigger, I'm going to add in a single product for the nine volt battery into the table. Let's execute all of these commands to create the table, and we'll see that default message here. It simply says one row is affected. Now let's customize this message by adding in a trigger. I'm going to click here at the end of line number 13 and come down to line 15, and then scroll my window down just a little bit so I have more room to type. We start creating the trigger with the CREATE TRIGGER keywords. Then we'll name the trigger and put it inside of the same schema…

Contents