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

Click here to load this message in the networking platform