BEFORE and AFTER Trigger

BEFORE and AFTER Trigger

Post by Tony Tory » Thu, 09 Sep 1999 04:00:00



In Oracle databases exists "before trigger" and "after trigger"

SQL Server also have this feature ???

 
 
 

BEFORE and AFTER Trigger

Post by Tibor Karasz » Thu, 09 Sep 1999 04:00:00


Tony,

Triggers in SQL Server are "after" triggers. No before triggers...

--
Tibor Karaszi
MCDBA, MCSE, MCSD, MCT, SQL Server MVP
Cornerstone Sweden AB
Please reply to the newsgroup only, not by email.


Quote:> In Oracle databases exists "before trigger" and "after trigger"

> SQL Server also have this feature ???


 
 
 

BEFORE and AFTER Trigger

Post by Neil Pik » Thu, 09 Sep 1999 04:00:00


Tony,

Nope, just after triggers

Quote:> In Oracle databases exists "before trigger" and "after trigger"

> SQL Server also have this feature ???

 Neil Pike MVP/MCSE.  Protech Computing Ltd
 (Please reply only to newsgroups)
 For SQL FAQ entries see

 or www.ntfaq.com/sql.html (+ ntfaq download)
 or http://www.swynk.com/faq/sql/sqlserverfaq.asp
 or http://www.sql-server.co.uk