How to create Unique Constraint on Multiple Columns in SQL Server - SQL Server/TSQL Tutorial Part 96
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/
Nesta página do site você pode assistir ao vídeo on-line How to create Unique Constraint on Multiple Columns in SQL Server - SQL Server/TSQL Tutorial Part 96 duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário TechBrothersIT 16 Maio 2016, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 7,103 vezes e gostou 19 espectadores. Boa visualização!
