Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 TRIGGER

Author  Topic 

DENIZ3E
Yak Posting Veteran

56 Posts

Posted - 2004-12-26 : 14:35:06
HI
does TRIGGER work in evry type of UPDATE or is there anything else for the trigger to trig?
example

"UPDATE TABLE SET colon=colon"

does the TRIGGER work in this command?

Kristen
Test

22859 Posts

Posted - 2004-12-26 : 14:56:32
Yes (provided its an UPDATE trigger - rather than, say, just a DELETE trigger)

Kristen
Go to Top of Page

rockmoose
SQL Natt Alfen

3279 Posts

Posted - 2004-12-26 : 16:08:02
quote:
Originally posted by DENIZ3E

HI
does TRIGGER work in evry type of UPDATE or is there anything else for the trigger to trig?


I only know of one type of UPDATE

rockmoose
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2004-12-27 : 02:26:56
An UPSERT ... now that's what I want

Kristen
Go to Top of Page
   

- Advertisement -