use current date as default value for a column

Question

Is there a way to set the default value of a column to DateTime Now in Sql Server   Example   table Event Id int  auto-increment  not null Description nvarchar 50  not null Date datetime not null   The line   Insert into Event Description  values  teste      should insert a row and the Date value should be the current date

User · Answer

You can use   Insert into Event Description Date  values  teste   GETDATE       Also  you can change your table so that  Date  has a default   GETDATE

User · Answer

Table creation Syntax can be like   Create table api key api key id INT NOT NULL IDENTITY 1 1   PRIMARY KEY  date added date DEFAULT  GetDate       Insertion query syntax can be like   Insert into api key values GETDATE

User · Answer

I have also come across this need for my database project   I decided to share my findings here    1  There is no way to a NOT NULL field without a default when data already exists  Can I add a not null column without DEFAULT value    2  This topic has been addressed for a long time   Here is a 2008 question  Add a column with a default value to an existing table in SQL Server   3  The DEFAULT constraint is used to provide a default value for a column   The default value will be added to all new records IF no other value is specified    https   www w3schools com sql sql default asp   4  The Visual Studio Database Project that I use for development is really good about generating change scripts for you   This is the change script created for my DB promotion    GO PRINT N Altering  dbo   PROD WHSE ACTUAL        GO ALTER TABLE  dbo   PROD WHSE ACTUAL      ADD  DATE  DATE DEFAULT getdate   NOT NULL    -  Here are the steps I took to update my database using Visual Studio for development   1  Add default value  Visual Studio SSDT  DB Project  table designer    2  Use the Schema Comparison tool to generate the change script   code already provided above   3  View the data BEFORE applying the change    4  View the data AFTER applying the change

User · Answer

CREATE TABLE Orders      O Id int NOT NULL      OrderNo int NOT NULL      P Id int      OrderDate date DEFAULT GETDATE      you can set default constraints while creating the table

User · Answer

Select Table Column Name where you want to get default value of Current date   ALTER TABLE    dbo   Table Name   ADD  CONSTRAINT  Constraint Name    DEFAULT  getdate    FOR  Column Name    Alter Table Query  Alter TABLE  dbo   Table Name        PDate   datetime  Default GetDate

User · Answer

To use the current date as the default for a date column  you will need to   1- open table designer  2- select the column  3- go to column proprerties  4- set the value of Default value or binding propriete To  getdate

User · Answer

Right click on the table and click on Design then click on column that you want to set default value   Then in bottom of page in column properties set Default value or binding to    getdate

User · Answer

Add a default constraint with the GETDATE   function as value   ALTER TABLE myTable    ADD CONSTRAINT CONSTRAINT NAME     DEFAULT GETDATE   FOR myColumn

[sql] use current date as default value for a column

Examples related to sql

Examples related to sql-server