Can we have more than one NULL in a column having unique
constraint?
Answer Posted / sasikumar
It is possible in Oracle database (NULL <> NULL) but not
possible in SQL server.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
what are the different ways to return the rowcount of a table?
What is a table called, if it has neither cluster nor non-cluster index? What is it used for?
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
What is table-valued sub query?
How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?
What is the beast way to write CTE in SQL Server ?
What is trigger and different types of Triggers?
What do you mean by tablesample?
What is the usage of the sign function?
What is co-related sub query?
Explain alternate key, candidate key and composite key in sql server?
What do you mean by stored techniques? How would we use it?
What is extent? Types of extents?
How do you send email on SQL Server?
What is the sql server agent?