Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2004

    Unanswered: export out of table

    I have two tables in a SQL server 2005 database. They have the same column names. I want to append older date captured in one table to the other. When I run a script to insert the data I get an identity error. Please help.

  2. #2
    Join Date
    Jan 2004
    In a large office with bad lighting
    Go look up Identity_Insert in BOL. Try it. Then come back with code and schema if you still need help.

    -- This is all just a Figment of my Imagination --

Posting Permissions

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