Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2002
    Posts
    2

    Unanswered: Primary Key problem in db transfer Access to SQL server

    I have an application initially made with Cold Fusion and Access.
    I have transferred the db from Access to SQL Server and all the code works fine except for the INSERT statement. SQL Server does not generate an automatic primary key... 'o( any ideas?

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002

    automatic primary key

    what was an autonumber in access is an IDENTITY column in sql/server

    if you are doing INSERT statements, you do not mention the identity column (same as in access)

    if you need to preserve the numbers that existed in the access tables, you can do that (look up the bcp utility and BULK INSERT KEEPIDENTITY in Books Online)

    rudy
    http://rudy.ca/

  3. #3
    Join Date
    Jul 2002
    Posts
    2

    It worked!

    Thanks!

Posting Permissions

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