Click below for Step by Step and Interview Q & A (dotnetinter) wrote,
Click below for Step by Step and Interview Q & A
dotnetinter

Can we insert NULL’s in to UNIQUE key ? ( SQL Server interview questions with answers)

This question was asked in TCS Mumbai for fresher level position. Below goes the answer  for the same.

The whole point about unique keys is to have unique value. So it treats NULL has one the values and allows you to insert one NULL value (stressing it one NULL value) in to the table.

Below is a nice SQL Server interview question video created by www.questpond.com which talks about difference between UNIQUE Key and Primary Key

Tags: csharp interview questions, it interview questions with answers, programming interview questions, sql interview answers, sql server interview questions, unique keys and null, unique vs primary key
Subscribe

  • Post a new comment

    Error

    Anonymous comments are disabled in this journal

    default userpic

    Your reply will be screened

    Your IP address will be recorded 

  • 0 comments