I need to set a timestamp (actual server system time) on each inserted row.
There is a primary key column named "doc_id"
I try using this trigger:
Create Trigger mytrigger On mytable
For Insert As
Update mytable
Set mystamp = getdate() where doc_id in (select doc_id from...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.