Options:-
a) 1
b) 2
c) More than 1
Answer :- Option a) 1
In SQL Server, we can Insert only one null value in a column where we have defined the Unique Constraint.
For Example , suppose we made a table test_unique, whose script is given below:-
create table test_unique (id int unique)
Now we insert the following values in it.
insert into test_unique(id) values (1)
insert into test_unique(id) values (2)
insert into test_unique(id) values (NULL)
insert into test_unique(id) values (3)
Here we inserted one null value before inserting 3.
If we see the records in the table , it shows the following data.
Let try to insert another NULL value and see what error it gives.
insert into test_unique(id) values (NULL)
Then it will gives the following error
So, In SQL server we can insert only one NULL value in a column where Unique constraint is defined.
Pingback: Charlotte North Carolina florist
Pingback: The Latest Information of Sexy Real Sex Doll
Pingback: Euro 2020
Pingback: click over here
Pingback: car hire Malta
Pingback: Istanaimpian2
Pingback: their website
Pingback: บาคาร่า
Pingback: Best Real Estate Agent Tallahassee
Pingback: fire doors melbourne
Pingback: 인터넷바카라
Pingback: 온라인카지노
Pingback: custom elevator decal
Pingback: 온라인 바카라 사이트
Pingback: tree removal nashville tn
Pingback: Offshore Company Formation
Pingback: didi free rides
Pingback: Small business website designs and marketing
Pingback: 메이저사이트
Pingback: custom instrument cases
Pingback: w88
Pingback: UBER SIGN UP CODE X6908
Pingback: บริการ เงิน ด่วน ใน ระบบ
Pingback: Bassett Caterers
Pingback: Dream Market
Pingback: Drogen
Pingback: เงิน ด่วน ดอกเบี้ย ถูก มาก
Pingback: w88 casino
Pingback: w88 win
Pingback: กังนัม คลินิก
Pingback: Ghana Mining Market 2020 Share, Trends, Segmentation, Analysis and Forecast to 2026