What is Default Constraint in SQL Server - SQL Server / TSQL Tutorial Part 90

Published: 17 May 2016
on channel: TechBrothersIT

1,587

SQL Server / TSQL Tutorial Scenario:
What is Default Constraint in SQL Server :
Default Constraint inserts the default value into a column when you do not provide value for column.

Let's understand by using below examples.

Scenario:
Let's say you need to create a dbo.Customer table with First Name, Last Name, Country Name and Region. If the user does not provide the values for Country Name and Region Columns you always want to insert Country Name='USA' and for Region='North America'.

Link to scripts used in SQL Server / TSQL Tutorial Video
http://www.techbrothersit.com/2016/05...

Check out our website for Different SQL Server, MSBI tutorials and interview questions
such as SQL Server Reporting Services(SSRS) Tutorial
SQL Server Integration Services(SSIS) Tutorial
SQL Server DBA Tutorial
SQL Server / TSQL Tutorial ( Beginner to Advance)
http://www.techbrothersit.com/

On this page of the site you can watch the video online What is Default Constraint in SQL Server - SQL Server / TSQL Tutorial Part 90 with a duration of hours minute second in good quality, which was uploaded by the user TechBrothersIT 17 May 2016, share the link with friends and acquaintances, this video has already been watched 1,587 times on youtube and it was liked by 5 viewers. Enjoy your viewing!

2,457