Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Declaring a default constraint when creating a table

Tags:

tsql

sql-server-2000

constraints

default

People also ask

What is constraint default constraint with example?

The DEFAULT constraint is used to set a default value for a column. The default value will be added to all new records, if no other value is specified.

Do it inline with the column creation:

[load_date] SMALLDATETIME NOT NULL
        CONSTRAINT [df_load_date] DEFAULT GETDATE()

I have used square brackets rather than quotes as many readers won't work with QUOTED_IDENTIFIERS on by default.

Related questions

SQL Server table creation date query
Confused about UPDLOCK, HOLDLOCK
MS SQL compare dates?
T-SQL: Looping through an array of known values
How to convert a datetime to string in T-SQL
Maximum size for a SQL Server Query? IN clause? Is there a Better Approach [duplicate]
Search for one value in any column of any table inside a database
How can I have multiple common table expressions in a single SELECT statement?
How do I fetch multiple columns for use in a cursor loop?
Calculating distance between two points (Latitude, Longitude)
SQL Row_Number() function in Where Clause
Listing information about all database files in SQL Server
In SQL Server, what does "SET ANSI_NULLS ON" mean?
INSERT vs INSERT INTO
Get first day of week in SQL Server
Cannot execute script: Insufficient memory to continue the execution of the program
How to get current instance name from T-SQL
Delete duplicate records in SQL Server?
What is PAGEIOLATCH_SH wait type in SQL Server?
Replace Default Null Values Returned From Left Outer Join

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!