Results 1 to 2 of 2

Thread: Identity Column

  1. #1
    Join Date
    Feb 2004
    Location
    Canada
    Posts
    16

    Unanswered: Identity Column

    How do you insert into a table that has an identity column aset of rows with predefined values for the identity column.
    I have tried to Set Identity_insert off and then insert but it didnt work.
    any ideas?

  2. #2
    Join Date
    Sep 2003
    Location
    The extremely Royal borough of Kensington, London
    Posts
    778
    SET IDENTITY_INSERT table ON

    Insert into table (columns) select * from table2
    Bessie Braddock: Winston, you are drunk!
    Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.

Posting Permissions

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