I can't find this anywhere on the google...
I have a table and want to insert the change date/time. Okay, this is easy, just do this in the field named CHGDATE:
CHGDATE TIMESTAMP NOT NULL IMPLICITLY HIDDEN FOR EACH ROW ON UPDATE AS ROW CHANGE TIMESTAMP,
But I also want the Current User. However, SQL doesn't let me specify:
CHANGEDBY Char(10) NOT NULL DEFAULT SYSTEM_USER