automatically creation on tablecurrent date and time in sql table code example
Example: sql create table with datetime automatically
CREATE TABLE myTable ( col1 int, createdDate datetime DEFAULT(getdate()), updatedDate datetime DEFAULT(getdate()) )