code to change the values generated by int identity

  • In column Artist_ID the values should be(1,2,3,4,5) with int identity

    but with from an unidentified error

    i got values of(1,3,4,5,6)

    instead of updating each field(except 1) is there any single code to correct the sequence of values?

  • Did you have a look at this article[/url] posted just the other day on this site?



    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

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

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