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