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


Please Help Members By Posting Answers For Below Questions

Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication

546


Can we write ddl in trigger?

498


do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

486


Tell me can we use custom code in ssrs?

601


How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

1633






what's sql server? : Sql server database administration

500


Explain unique key in sql server?

540


How to transfer an existing table from one schema to another schema in ms sql server?

513


What are approximate numeric data types in ms sql server?

591


What is database architecture? : SQL Server Architecture

555


Tell me what is difference between clustered and non clustered index?

558


What do you mean by an execution plan? Why is it used?

535


How to write an inner join with the where clause in ms sql server?

558


What is transact-sql ddl trigger?

634


How is sql server used?

547