Trigger for update, insert

[athuraliya]

I want to write a trigger to run on any insert or update so that whatever values inserted, a desired value should be entered to a particular coloumn.
Let's say my table is T1 and it has columns a(number),b(Text),c(DateTime) . I want the trigger force to take GETDATE() value for column c always(on any update or insert) The main problem I have is in the trigger, how do I refer to the record which is being updated or inserted?
Has any body an idea?
Thanks in advance

 

[tlbroadbent]

The logical table, Inserted, contains the updated record. You can refer to it as you would any table but only in the context of the Trigger. See the documentation in SQL BOL or at...

http://msdn.microsoft.com/library/en-us/tsqlref/ts_create2_7eeq.asp

Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[athuraliya]

Yea I know, but as far as I know, we can't change the content of the logical table 'inserted'. I want to make the change I need to the physical record just entered (or updated)
Thanks

 

[tlbroadbent]

I assume you physical record has a key or unique identifier. You can get the key columns from the Inserted table and use the keys to update the record. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.