Geeks Talk

Prepare for your Next Interview




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 ...


Go Back   Geeks Talk > Databases > SQL Server

Register FAQ Members List Calendar Mark Forums Read
  #1 (permalink)  
Old 03-19-2008
Contributing Member
 
Join Date: Jul 2007
Posts: 43
Thanks: 1
Thanked 1 Time in 1 Post
priyasp_msit is on a distinguished road
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
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 03-20-2008
Moderator
 
Join Date: Jun 2007
Location: Bangalore,India
Posts: 1,432
Thanks: 8
Thanked 126 Times in 113 Posts
debasisdas will become famous soon enoughdebasisdas will become famous soon enough
Re: what is unique key

Is that the case ?

Different database have different ways of handling NULL.
Reply With Quote
  #3 (permalink)  
Old 03-28-2008
chennaprashanth's Avatar
Contributing Member
 
Join Date: Mar 2008
Location: Pune
Posts: 30
Thanks: 0
Thanked 9 Times in 7 Posts
chennaprashanth is on a distinguished road
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,
Reply With Quote
  #4 (permalink)  
Old 04-22-2008
Junior Member
 
Join Date: Apr 2008
Location: visakhaptnam
Posts: 18
Thanks: 2
Thanked 2 Times in 1 Post
ushalakshmi is on a distinguished road
Re: what is unique key

Hey priya,

Unique key accept only one Null in sql Server.
Reply With Quote
Reply

  Geeks Talk > Databases > SQL Server


Thread Tools
Display Modes


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.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
Copyright © 2008 GeekInterview.com. All Rights Reserved