VB boolean to SQL bit conversion?

• Vikka

  Hall of Fame

  Points: 3715

  More actions

  April 4, 2007 at 2:55 pm

  #698653

  yes this is what I did. I made primary key with all three columns. I still think this is not right. Those three fields should be foreign keys because in some other tables they are ALREADY primary keys.

• Gift Peddie

  SSC Guru

  Points: 73570

  More actions

  April 4, 2007 at 5:38 pm

  #698684

  (After that I was asked to add one more column  [column3] [datetime] NOT NULL. Combination of all three columns should be unique. I want to add that column3 to the primary key but don't know how to do it after table was already created.)

  The above is the reason I gave you that answer but the BOL(books online) is better than most books run a search for index column include it is a new feature which is an implict composite so you can just add the column to any index you create as needed.  Hope this helps.

   

  Kind regards,
  Gift Peddie