Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Assigning default value to a field
Message
From
22/02/2006 16:36:35
 
 
To
22/02/2006 16:28:54
Jerry Tovar
Dana Corporation Dana It
Maumee, Ohio, United States
General information
Forum:
Microsoft SQL Server
Category:
Database design
Environment versions
SQL Server:
SQL Server 2000
Miscellaneous
Thread ID:
01098263
Message ID:
01098267
Views:
13
>I am creating a table using the MS SQL Server Management Studio. I want to create a 'DateCreated' column in my table and have a default value of today's date/time. I created the column with a data type datetime, but what do I put into the 'Default value or binding' property to make the column default to today's date when a new record is added to the table?
>
>Thanks,
>
>Jerry
getdate()
Previous
Reply
Map
View

Click here to load this message in the networking platform