 |  |  |  |  |  |  |  |
create update trigger with parameters mssql
Please support our MS SQL advertiser: Intel Parallel Studio Home
 |
hi
i want to create a trigger for update in mssql.
in my trigger i want to know which row was updated
how can i achieve this info ?
i want to create a trigger for update in mssql.
in my trigger i want to know which row was updated
how can i achieve this info ?
•
•
Join Date: Aug 2006
Posts: 2,065
Reputation: 
Solved Threads: 256
When you create trigger After
AS play with columns_updated() function read in http://msdn.microsoft.com/en-us/libr...4(SQL.80).aspx BI Developer | LINKdotNET
B.Sc Computer Science, Helwan University
Technical blog | http://ramymahrous.wordpress.com
LinkedIn | http://www.linkedin.com/in/ramymahrous
B.Sc Computer Science, Helwan University
Technical blog | http://ramymahrous.wordpress.com
LinkedIn | http://www.linkedin.com/in/ramymahrous
Use the "inserted" keyword in the trigger.
if you use inside the trigger code:
SELECT * FROM inserted
only the updated rows will be returned.
if you use inside the trigger code:
SELECT * FROM inserted
only the updated rows will be returned.
Doron Saar,
Nob Hill Software - tools for database people (+ free stuff!) Nob Hill Software - tools for database people (+ free stuff!)
www.nobhillsoft.com
Nob Hill Software - tools for database people (+ free stuff!) Nob Hill Software - tools for database people (+ free stuff!)
www.nobhillsoft.com
|
Other Threads in the MS SQL Forum
- Previous Thread: how to remove redundant records
- Next Thread: SSRS05: concatenate table cells if other columns are equal
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest MS SQL Posts
- Today's Posts
- Unanswered Threads
