Prepare for your Next Interview

• GeekInterview
• Knowledge base
• Interview Questions
• Tech FAQs

what is unique key

This is a discussion on what is unique key within the SQL Server forums, part of the Databases category; unique does not accept duplicate values but accept null values in oracle but this is different concept for sqlserver why? only accept one null values after that did not accept ...

Geeks Talk > Databases > SQL Server what is unique key

User Name Remember Me? Password

Register

FAQ

Members List

Calendar

Mark Forums Read

Thread Tools

Display Modes

#1 (permalink)   03-19-2008

priyasp_msit Contributing Member   Join Date: Jul 2007 Posts: 43 Thanks: 1 Thanked 1 Time in 1 Post

what is unique key unique does not accept duplicate values but accept null values in oracle but this is different concept for sqlserver why? only accept one null values after that did not accept more null values tell me any body

Sponsored Links

#2 (permalink)   03-20-2008

debasisdas Moderator   Join Date: Jun 2007 Location: Bangalore,India Posts: 1,432 Thanks: 8 Thanked 126 Times in 113 Posts

Re: what is unique key Is that the case ? Different database have different ways of handling NULL.

#3 (permalink)   03-28-2008

chennaprashanth Contributing Member   Join Date: Mar 2008 Location: Pune Posts: 30 Thanks: 0 Thanked 9 Times in 7 Posts

Re: what is unique key Hai Priya, Unique Key does not accept Duplicate values and it can accept Only ONE NULL value even in SQL Server. Cheers Prashanth Chenna,

#4 (permalink)   04-22-2008

ushalakshmi Junior Member   Join Date: Apr 2008 Location: visakhaptnam Posts: 18 Thanks: 2 Thanked 2 Times in 1 Post

Re: what is unique key Hey priya, Unique key accept only one Null in sql Server.

Geeks Talk > Databases > SQL Server

« Delete Contents of Table Permanently | Database Access »

Thread Tools

Show Printable Version Email this Page

Display Modes

Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
English Words which are Unique	K.K.Rajiv	Brainteasers	12	12-15-2007 01:31 AM
unique login name	smita76	Unix/Linux	1	12-09-2007 03:09 PM
Oracle Null and Unique value	Subashini.Ramasamy	Oracle	3	06-16-2007 09:13 AM
Unique with NotNull??	vcyogi	SQL Server	2	06-08-2007 10:15 AM
Usage of Unique Index	RyanJames	Oracle	2	10-13-2006 07:00 PM

All times are GMT -4. The time now is 08:45 AM.