set char field stud_id to unique

• denimblue

  Mr or Mrs. 500

  Points: 594

  More actions

  March 25, 2008 at 9:22 am

  #187708

  char field with over 30,000 rows 6890 of them are null is it possible to make this column unique?

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  March 25, 2008 at 9:42 am

  #793596

  From BOL:

  ...only one null value is allowed per column.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question

• Mark Cowne

  One Orange Chip

  Points: 26952

  More actions

  March 25, 2008 at 9:57 am

  #793609

  Use an indexed view

  http://www.sqlservercentral.com/Forums/FindPost471408.aspx

  ____________________________________________________

  Deja View - The strange feeling that somewhere, sometime you've optimised this query before

  How to get the best help on a forum

  http://www.sqlservercentral.com/articles/Best+Practices/61537