What is the difference between for and after trigger?

Question

What is the difference between for and after trigger?

invaliddba

Default port

Points: 1450
More actions
May 27, 2011 at 12:07 pm

#250817

What is the difference between for and after trigger?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

After trigger runs after an action has occurred on the table in question.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Lowell SSC Guru Points: 323518 More actions · Answer 2

In SQL Server, they are the same thing...in ORACLE and maybe other DBMS systems an AFTER trigger is different.

The first ingredient in properly employing triggers is to understand the differences between AFTER and INSTEAD OF triggers. AFTER triggers are the same type of trigger that is available in previous versions of SQL Server. They are also known as "FOR triggers" or even simply as "triggers" since they were the only type of trigger available prior to SQL Server 2000.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Evil Kraig F SSC Guru Points: 100851 More actions · Answer 3

The two triggers are "instead of" and "after" for SQL Server. One triggers on the data on its way in, the other triggers with access to the data but stops the initiating action. So, if you have an INSTEAD OF UPDATE trigger, you update a row, and the trigger fires but the row won't update unless you include another update IN the trigger. It allows for some pretty serious interruption when an event occurs.

- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA