SQL Server - add createdAt and updatedAt columns, automatically updates

add-timestamps.sql

ALTER TABLE myTable
add createdAt datetime
CONSTRAINT DF_myTable_createdat DEFAULT GETDATE()

ALTER TABLE myTable
add updatedAt datetime
CONSTRAINT DF_myTable_updatedAt DEFAULT GETDATE()

go

create trigger trg_myTable_update on myTable for update as
begin
  update myTable
	set updatedAt = getDate()
	from myTable inner join deleted d
	on myTable.id=d.id
end

go

excellent code. thank you. for others who want to use this and may not know what the deleted table is referred to in this code--it's a table that SQL Server uses during updates and deletes to hold the records being changed.

See link below or search google to understand why the from myTable inner join deleted d on myTable.id=d.id is necessary:

https://www.mssqltips.com/sqlservertip/2342/understanding-sql-server-inserted-and-deleted-tables-for-dml-triggers/

is there any other way to perform auto update timestamp in SQL server instead of triggering ?