Interested to Buy Any Domain ? << Click Here >> for more details...
Can we have more than one NULL in a column having unique
constraint?
- 12 Answers
- 16018 Views
- 247Customer, I also Faced
- E-Mail Answers
Answer Posted / krishnaraj p n
UNIQUE constraints can accept NULL just once. If the
constraint is defined in a combination of fields, then
every field can accept NULL and can have some values on
them, as long as the combination values is unique.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is a hint?
What is attribute hierarchy? : sql server analysis services, ssas
What is difference between join and natural join?
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
What is the New in SQL server 2008?
What is the difference between implicit and explicit transaction?
How to access the deleted record of an event?
What the different topologies in which replication can be configured?
What is the current pricing model of SQL Azure?
What is the syntax for encrypting a column in SQL Server?
What are commonly used mssql functions in php?
Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many
How to see existing views in ms sql server?
You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?
Can two different columns be merged into single column? Show practically?
