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.