reseed auto_increment to specific number?

The name of the pictureThe name of the pictureThe name of the pictureClash Royale CLAN TAG#URR8PPP





.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty margin-bottom:0;







up vote
1
down vote

favorite












Is it possible to set the identity column of a table to start from a specific value?



I'm converting an ETL stage from mysql to a sql server database where a staging database loads records with a unique ID starting from the maximum value in the main database (which is not auto-incrementing). The mysql went like this:



SET @s = Concat('alter table table_1 auto_increment=',coalesce(@indexmaxt,0)+1);


Ideally this is what I want to do:



DBCC CHECKIDENT (table_1 , RESEED, @indexmaxt+1)


Is this possible or is this impossible in SQL server






sql-server mysql etl auto-increment







share|improve this question























  • @Akina Sorry I realised I forgot to mention that I'm doing this in a sql server database
    – Exostrike
    1 hour ago
















up vote
1
down vote

favorite












Is it possible to set the identity column of a table to start from a specific value?



I'm converting an ETL stage from mysql to a sql server database where a staging database loads records with a unique ID starting from the maximum value in the main database (which is not auto-incrementing). The mysql went like this:



SET @s = Concat('alter table table_1 auto_increment=',coalesce(@indexmaxt,0)+1);


Ideally this is what I want to do:



DBCC CHECKIDENT (table_1 , RESEED, @indexmaxt+1)


Is this possible or is this impossible in SQL server






sql-server mysql etl auto-increment







share|improve this question























  • @Akina Sorry I realised I forgot to mention that I'm doing this in a sql server database
    – Exostrike
    1 hour ago












up vote
1
down vote

favorite









up vote
1
down vote

favorite











Is it possible to set the identity column of a table to start from a specific value?



I'm converting an ETL stage from mysql to a sql server database where a staging database loads records with a unique ID starting from the maximum value in the main database (which is not auto-incrementing). The mysql went like this:



SET @s = Concat('alter table table_1 auto_increment=',coalesce(@indexmaxt,0)+1);


Ideally this is what I want to do:



DBCC CHECKIDENT (table_1 , RESEED, @indexmaxt+1)


Is this possible or is this impossible in SQL server






sql-server mysql etl auto-increment







share|improve this question















Is it possible to set the identity column of a table to start from a specific value?



I'm converting an ETL stage from mysql to a sql server database where a staging database loads records with a unique ID starting from the maximum value in the main database (which is not auto-incrementing). The mysql went like this:



SET @s = Concat('alter table table_1 auto_increment=',coalesce(@indexmaxt,0)+1);


Ideally this is what I want to do:



DBCC CHECKIDENT (table_1 , RESEED, @indexmaxt+1)


Is this possible or is this impossible in SQL server






sql-server mysql etl auto-increment




sql-server mysql etl auto-increment






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited 1 hour ago

























asked 1 hour ago









Exostrike

286




286











  • @Akina Sorry I realised I forgot to mention that I'm doing this in a sql server database
    – Exostrike
    1 hour ago
















  • @Akina Sorry I realised I forgot to mention that I'm doing this in a sql server database
    – Exostrike
    1 hour ago















@Akina Sorry I realised I forgot to mention that I'm doing this in a sql server database
– Exostrike
1 hour ago




@Akina Sorry I realised I forgot to mention that I'm doing this in a sql server database
– Exostrike
1 hour ago










1 Answer
1






active

oldest

votes

















up vote
2
down vote



accepted










This works, does that answer your question?



create table dbo.test (id int identity(1,1), value int);


declare @indexmaxt int = 9999,@indexmaxt2 int;
SET @indexmaxt2 = @indexmaxt+1;
DBCC CHECKIDENT ('dbo.test' , RESEED, @indexmaxt2);


insert into dbo.test(value) values(1);

select * from dbo.test;


Results:
id 10000

value
1






share|improve this answer




















    Your Answer







    StackExchange.ready(function()
    var channelOptions =
    tags: "".split(" "),
    id: "182"
    ;
    initTagRenderer("".split(" "), "".split(" "), channelOptions);

    StackExchange.using("externalEditor", function()
    // Have to fire editor after snippets, if snippets enabled
    if (StackExchange.settings.snippets.snippetsEnabled)
    StackExchange.using("snippets", function()
    createEditor();
    );

    else
    createEditor();

    );

    function createEditor()
    StackExchange.prepareEditor(
    heartbeatType: 'answer',
    convertImagesToLinks: false,
    noModals: false,
    showLowRepImageUploadWarning: true,
    reputationToPostImages: null,
    bindNavPrevention: true,
    postfix: "",
    onDemand: true,
    discardSelector: ".discard-answer"
    ,immediatelyShowMarkdownHelp:true
    );



    );













     

    draft saved


    draft discarded


















    StackExchange.ready(
    function ()
    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f219050%2freseed-auto-increment-to-specific-number%23new-answer', 'question_page');

    );

    Post as a guest

















    1 Answer
    1






    active

    oldest

    votes








    1 Answer
    1






    active

    oldest

    votes









    active

    oldest

    votes






    active

    oldest

    votes








    up vote
    2
    down vote



    accepted










    This works, does that answer your question?



    create table dbo.test (id int identity(1,1), value int);


    declare @indexmaxt int = 9999,@indexmaxt2 int;
    SET @indexmaxt2 = @indexmaxt+1;
    DBCC CHECKIDENT ('dbo.test' , RESEED, @indexmaxt2);


    insert into dbo.test(value) values(1);

    select * from dbo.test;


    Results:
    id 10000

    value
    1






    share|improve this answer
























      up vote
      2
      down vote



      accepted










      This works, does that answer your question?



      create table dbo.test (id int identity(1,1), value int);


      declare @indexmaxt int = 9999,@indexmaxt2 int;
      SET @indexmaxt2 = @indexmaxt+1;
      DBCC CHECKIDENT ('dbo.test' , RESEED, @indexmaxt2);


      insert into dbo.test(value) values(1);

      select * from dbo.test;


      Results:
      id 10000

      value
      1






      share|improve this answer






















        up vote
        2
        down vote



        accepted







        up vote
        2
        down vote



        accepted






        This works, does that answer your question?



        create table dbo.test (id int identity(1,1), value int);


        declare @indexmaxt int = 9999,@indexmaxt2 int;
        SET @indexmaxt2 = @indexmaxt+1;
        DBCC CHECKIDENT ('dbo.test' , RESEED, @indexmaxt2);


        insert into dbo.test(value) values(1);

        select * from dbo.test;


        Results:
        id 10000

        value
        1






        share|improve this answer












        This works, does that answer your question?



        create table dbo.test (id int identity(1,1), value int);


        declare @indexmaxt int = 9999,@indexmaxt2 int;
        SET @indexmaxt2 = @indexmaxt+1;
        DBCC CHECKIDENT ('dbo.test' , RESEED, @indexmaxt2);


        insert into dbo.test(value) values(1);

        select * from dbo.test;


        Results:
        id 10000

        value
        1







        share|improve this answer












        share|improve this answer



        share|improve this answer










        answered 1 hour ago









        Randi Vertongen

        2665




        2665



























             

            draft saved


            draft discarded















































             


            draft saved


            draft discarded














            StackExchange.ready(
            function ()
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f219050%2freseed-auto-increment-to-specific-number%23new-answer', 'question_page');

            );

            Post as a guest
































































            Comments

            Post a Comment

            Popular posts from this blog

            White Anglo-Saxon Protestant

            Image
            White Anglo-Saxon Protestants ( WASPs ) are a social group of wealthy and well-connected white Americans, of Protestant and predominantly British ancestry, who trace their ancestry to the American colonial period. Until at least the 1960s, this group has dominated American society and culture and dominated in the leadership of the Whig and Republican parties. They usually are very well placed in major financial, business, legal and academic institutions and had close to a monopoly of elite society due to intermarriage and nepotism. [1] During the latter half of the twentieth century, outsider ethnic and racial groups grew in influence and WASP dominance weakened. Americans are increasingly criticizing the WASP hegemony and disparaging WASPs as the epitome of "the Establishment". The Random House Unabridged Dictionary (1998) says the term is "Sometimes Disparaging and Offensive". [2] [3] The term WASP is often used as a pejorative to classify their historical dom...
            Read more

            Is the Concept of Multiple Fantasy Races Scientifically Flawed? [closed]

            Image
            Clash Royale CLAN TAG #URR8PPP up vote 2 down vote favorite Many fantasy worlds have multiple humanoid species (elves, orcs, humans, etc) living in the same world, in addition to that, they often have the ability to interbreed. And I can't help but question their believability... fantasy-races reproduction interspecies-relations share | improve this question edited Aug 9 at 14:46 Michael Kjörling ♦ 21.1k 10 85 161 asked Aug 9 at 13:13 Chlodio 118 6 closed as unclear what you're asking by MichaelK, Gryphon, John, Vincent, Frostfyre Aug 9 at 15:25 Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question. ...
            Read more

            One-line joke

            A one-liner is a joke that is delivered in a single line. A good one-liner is said to be pithy - concise and meaningful. [1] Comedians and actors use this comedic method as part of their act, e.g. Jimmy Carr, Tommy Cooper, Rodney Dangerfield, Norm Macdonald, Ken Dodd, Stewart Francis, Zach Galifianakis, Mitch Hedberg, Anthony Jeselnik, Milton Jones, Shappi Khorsandi, Jay London, Mark Linn-Baker, Demetri Martin, Groucho Marx, Dan Mintz, Emo Philips, Tim Vine, Steven Wright and Henny Youngman and Arnold Schwarzenegger. [ citation needed ] Many fictional characters are also known to deliver one-liners, including James Bond, who usually includes pithy and laconic quips after disposing of a villain. [ citation needed ] Examples "A baby seal walks into a club." "A dyslexic man walks into a bra." (Anonymous) "There are three types of people, those who can count and those who can't." "Venison's dear, isn't it?" (Jimmy Carr) "An escala...
            Read more