automatically set "creation date ms sql on insert code example

Example: sql create table with datetime automatically

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