Automatic Adding Current DateTime In TableField

Question

I am using SQL SERVER 2005 and i am also newbie to SQL SERVER

now i need to know that is there any way or any technique in SQL SERVER 2005

such that as soon as i add new record in table then current date-time should be added in to any given field of table.

Example:

Suppose i have CUSTOMER table and it has fields say CustomerID,CustomerName,....,DateTime. now whenever new customer added in this table then current date-time should be automatically added in to DateTime Field of CUSTOMER table.

Answer 1

In SSMS one can set the Default value or binding property of the appropriate column of the table property to getdate().