Sample Header Ad - 728x90

Trigger to update a column in a new record to CURRENT_TIMESTAMP as it is inserted

2 votes
1 answer
6464 views
Ok, so I'm trying to update a column to a CURRENT_TIMESTAMP in a specific record whenever the record is originally inserted. This is what I've got but otherwise I am lost. CREATE TRIGGER dbo.TrgUpnInsert ON [CNLH Security Authentication].dbo.DateTimestamp AFTER INSERT, INSERT INTO [CNLH Security Authentication].dbo.EntranceInformation (DateTimestamp) Values (CURRENT_TIMESTAMP);
Asked by AArmentrout (21 rep)
Nov 17, 2016, 05:45 PM
Last activity: Jan 19, 2018, 05:29 AM