Al's BrainDump
Navigation
¶
Main Page
Random Page
Create a new Page
All Pages
Categories
Administration
File Management
Login/Logout
Language Selection
Your Profile
Create Account
Quick Search
»
Advanced Search »
Discuss (0)
View Page Code
History
Triggers
Print
RSS
Modified on 2008/04/21 16:46
by
Administrator
Categorized as
Uncategorized
(10)
»
Total Return Swap
»
Trans Log
»
Triggers
[X]
»
Structural Design Patterns
»
Swaps
»
T-SQL 2005
»
Table Types
»
TechInterviewsSQL
»
Threads
»
Top Tried Wines
»
Total Return Swap
»
Trans Log
»
Triggers
There are two tables available to Trigger, INSERTED and DELETED, again depends upon the event like update, delete, or insert.
In case of update you can query like this select * from DELETED
for the old data select * from INSERTED
for the new data
ScrewTurn Wiki
version 3.0.5.600. Some of the icons created by
FamFamFam
.