Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

Can we use more than one null value for unique key?

Answer Posted / raman

Primary Key is a combination of Unique and NOT NULL
Constraints so it can’t have duplicate values or any NUll

Whereas for Oracle UNIQUE Key can have any number of NULL
but for SQL Server It can have only one NULL

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can unique keys be null?

858


What is an emotional trigger?

940


Does execute immediate commit?

1160


what is offset-fetch filter in tsql? : Transact sql

901


what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba

1011


How many postgresql users are there, worldwide?

1009


The select into statement is most often used to create backup copies of tables or for archiving records?

1013


How many types of triggers are there in pl sql?

1022


Explain locks? : Transact sql

965


What are the disadvantages of not performing database normalization?

1111


What are the benefits of triggers?

1127


How many parts of a pl sql block are optional?

1043


Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

1004


What are pl sql procedures?

973


How to pronounce postgresql?

1013