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

preview_player
Показать описание
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

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)
Рекомендации по теме
Комментарии
Автор

how can i change default constraint value by alter command?

barakobama
visit shbcf.ru