How to create Unique Constraint on Multiple Columns in SQL Server - SQL Server/TSQL Tutorial Part 96

Publicado el: 16 mayo 2016
en el canal de: TechBrothersIT

7,103

SQL Server / TSQL Tutorial Scenario:

If you have noticed the insert statement, In First Record I have put both Null values for FirstName and Last Name. In 2nd record I used the value 'Aamir' for first name and Null for Last Name. In 3rd record vice versa of 2nd record. From here what we understand that the unique constraint is working on both column values. As long as the combined value from both columns is unique, it is going to let us insert even one of them is null.

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/

En esta página del sitio puede ver el video en línea How to create Unique Constraint on Multiple Columns in SQL Server - SQL Server/TSQL Tutorial Part 96 de Duración hora minuto segunda en buena calidad , que subió el usuario TechBrothersIT 16 mayo 2016, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 7,103 veces y le gustó 19 a los espectadores. Disfruta viendo!

234