Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to create a log of all updates...
Message
De
12/03/2003 07:01:43
Eudoxio Junior
Hospital Sao Marcos
Teresina, Brésil
 
 
À
11/03/2003 09:53:45
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Sécurité
Divers
Thread ID:
00764180
Message ID:
00764684
Vues:
22
Ok,
I've the name of the columns updated so I want to compare the old value and the new value using deleted and inserted tables...

I put the following test statement into the update trigger:
...
set @sql= 'select * from deleted'
exec sp_executesql @sql
...
But everytime I update the table the trigger returns
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'deleted'.
How can I reference deleted and inserted tables to know which values where changed?
Atenciosamente,
Eudóxio Júnior
Hospital São Marcos
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform