Results 1 to 2 of 2

Thread: unique

  1. Mar 7th, 2001, 07:14 AM #1
    bhaskerg
    bhaskerg is offline

    Thread Starter
    Lively Member bhaskerg's Avatar
    Join Date
    Mar 2001
    Location
    india
    Posts
    68
    why is that u can insert more than 1 NULL value to a filed declared as unique in oracle and ms access and not in others ( ms sql , sybase...)......which one is right? allowing NULL values to be inserted or not?
    Reply With Quote Reply With Quote
  2. Mar 7th, 2001, 04:06 PM #2
    jxiong
    jxiong is offline
    Hyperactive Member
    Join Date
    Oct 2000
    Posts
    303

    only opinion

    unique means no duplication, and since you said
    insert nulls, i assumed you tried to insert many
    nulls which it should error because they are not
    unique.

    For example:

    You have a table which has 1000 rows and the 5th
    column contains nulls, if you try to create a unique
    index on that field, it should not let you do it because
    it is not unique ( all nulls or have similar values).
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width