SQL Server - Automatically insert date

Asked By david stevenson on 30-Nov-05 05:57 AM
Can I set up a column in a SQL database to automatically insert todays date?

I have tried setting the default value in Enterprise Manager to date() and the formula to date() as well, but this does not work. Any ideas?

answer

Asked By david stevenson on 30-Nov-05 06:07 AM
getdate() was what I was looking for.

Learn Microsoft applications

Asked By Maydane Okiye on 05-Dec-05 01:07 PM
Sql server 2000.
I cerated tables in vb.net 2003 and when i add some details to tables.
the autonumber didnt create automatically.

how can i solve with this problem?