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?