ms sql auto timestamp field code example

Example: sql create table with datetime automatically

CREATE TABLE myTable ( col1 int, createdDate datetime DEFAULT(getdate()), updatedDate datetime DEFAULT(getdate()) )