VB boolean to SQL bit conversion?

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

  • (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

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply