use current date as default value for a column

Question

Is there a way to set the default value of a column to DateTime.Now in Sql Server?

Example:

table Event Id int (auto-increment) not null Description nvarchar(50) not null Date datetime not null 

The line:

Insert into Event(Description) values('teste'); 

should insert a row and the Date value should be the current date.

Answer 1

Add a default constraint with the GETDATE() function as value.

ALTER TABLE myTable    ADD CONSTRAINT CONSTRAINT_NAME     DEFAULT GETDATE() FOR myColumn