SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Member
    Join Date
    Jan 2004
    Location
    Aldershot
    Posts
    19
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    MS-SQL Server 2k - Unique values (except Null) in a non-unique column

    We've have a couple of fields in our Database that must contain unique values. However, we also need to be able to have these fields set as null if no value has been set.
    At the moment if you set the field so that values must be unique it only allows a single null value.

    Does anyone know how I can get around this problem?

    Tia,

    Andy.

  2. #2
    SitePoint Enthusiast
    Join Date
    Apr 2004
    Location
    TX
    Posts
    71
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    argg...nevermind, thought I had an answer.

  3. #3
    SitePoint Wizard
    Join Date
    Jan 2001
    Location
    Milton Keynes, UK
    Posts
    1,011
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

  4. #4
    SitePoint Member
    Join Date
    Jan 2004
    Location
    Aldershot
    Posts
    19
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks for that link.


Bookmarks

Posting Permissions

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