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
 General SQL Server Forums
 New to SQL Server Programming
 triggers

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-03-17 : 08:19:34
prasad writes "purpose of triggers other than insert, update,delete?"

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2006-03-17 : 08:22:39
referential integrity



KH

Choice is an illusion, created between those with power, and those without.
Concordantly, while your first question may be the most pertinent, you may or may not realize it is also the most irrelevant

Go to Top of Page

nr
SQLTeam MVY

12543 Posts

Posted - 2006-03-17 : 11:58:17
inser, update, delete are the types of triggers rather than the function - also instead of and after.
Another main use of triggers is Audit trails.


==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page
   

- Advertisement -