Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Assigning default value to a field
Message
De
22/02/2006 16:28:54
Jerry Tovar
Dana Corporation Dana It
Maumee, Ohio, États-Unis
 
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Conception bases de données
Titre:
Assigning default value to a field
Versions des environnements
SQL Server:
SQL Server 2000
Divers
Thread ID:
01098263
Message ID:
01098263
Vues:
63
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform