Manually incrementing a field

Results 1 to 2 of 2

Thread: Manually incrementing a field

  1. #1
    Joey Guest

    Default Manually incrementing a field

    I had to import an ACCESS table into my SQL database. I now have a column (ID) which WAS an identity field, but had to be changed to a CHAR for the import. Anyways, thats not the issue.<BR><BR>What I need to do is increment the ID column +1 for the whole table. And then when it&#039;s through, I&#039;ll change it back to an IDENTITY field.<BR><BR>Thanks for the help.<BR><BR>

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default RE: Manually incrementing a field

    make the column in the target table char too and just select from the source into the target and after that is done cange the column datatype.<BR><BR>

Posting Permissions

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