|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
 |
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
|
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
Dev Articles Community Forums Sponsor:
|
|
|
|
#1
July 27th, 2003, 03:42 AM
|
|||
|
|||
which rwo is updated
when a row is updated
i need to know which row is it in order to write a trigger based on that row can SQL server2000 tell me that ??? doese it have a function that gets the updated row [GETROWUPDATED() ... i hope ] rteturns row number for example??
|
|
#2
August 1st, 2003, 12:21 PM
|
|||
|
|||
|
If i am not mistaken you will have all the information you need for your trigger, by reading the deleted and the inserted table.
The deleted and inserted temporary table contain all the fields from the table where you did an update. see http://www.devarticles.com/art/1/36
__________________
- Rogier Doekes
|
|
| Viewing: Dev Articles Community Forums > Databases > Microsoft SQL Server > which rwo is updated |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
