{"id":853,"date":"2023-02-07T07:25:32","date_gmt":"2023-02-07T11:25:32","guid":{"rendered":"https:\/\/www.searchenginegenie.com\/programming-blog\/?p=853"},"modified":"2023-02-07T07:25:34","modified_gmt":"2023-02-07T11:25:34","slug":"update-ids-in-identity-table-in-sql-server","status":"publish","type":"post","link":"https:\/\/www.searchenginegenie.com\/programming-blog\/update-ids-in-identity-table-in-sql-server\/","title":{"rendered":"Update IDs in identity table in SQL server"},"content":{"rendered":"\n
  1. Create a temporary table with the same schema as the identity table.<\/li>
  2. Copy the data from the identity table into the temporary table.<\/li>
  3. Update the IDs in the temporary table to the new values.<\/li>
  4. Truncate the identity table.<\/li>
  5. Copy the data in the temporary table back into the identity table.<\/li>
  6. Drop the temporary table.<\/li><\/ol>\n\n\n\n

    <\/p>\n\n\n\n

    CREATE TABLE #TempTable (
    ID INT IDENTITY,
    Column1 VARCHAR(50),
    Column2 VARCHAR(50)
    );<\/p>\n\n\n\n

    INSERT INTO #TempTable
    SELECT * FROM IdentityTable;<\/p>\n\n\n\n

    UPDATE #TempTable
    SET ID = NewValue
    WHERE ID = OldValue;<\/p>\n\n\n\n

    TRUNCATE TABLE IdentityTable;<\/p>\n\n\n\n

    INSERT INTO IdentityTable
    SELECT * FROM #TempTable;<\/p>\n\n\n\n

    DROP TABLE #TempTable;<\/p>\n","protected":false},"excerpt":{"rendered":"

    Create a temporary table with the same schema as the identity table. Copy the data from the identity table into the temporary table. Update the IDs in the temporary table to the new values. Truncate the identity table. Copy the data in the temporary table back into the identity table. Drop the temporary table. CREATE […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-853","post","type-post","status-publish","format-standard","hentry","category-programming"],"_links":{"self":[{"href":"https:\/\/www.searchenginegenie.com\/programming-blog\/wp-json\/wp\/v2\/posts\/853","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.searchenginegenie.com\/programming-blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.searchenginegenie.com\/programming-blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.searchenginegenie.com\/programming-blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.searchenginegenie.com\/programming-blog\/wp-json\/wp\/v2\/comments?post=853"}],"version-history":[{"count":1,"href":"https:\/\/www.searchenginegenie.com\/programming-blog\/wp-json\/wp\/v2\/posts\/853\/revisions"}],"predecessor-version":[{"id":854,"href":"https:\/\/www.searchenginegenie.com\/programming-blog\/wp-json\/wp\/v2\/posts\/853\/revisions\/854"}],"wp:attachment":[{"href":"https:\/\/www.searchenginegenie.com\/programming-blog\/wp-json\/wp\/v2\/media?parent=853"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.searchenginegenie.com\/programming-blog\/wp-json\/wp\/v2\/categories?post=853"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.searchenginegenie.com\/programming-blog\/wp-json\/wp\/v2\/tags?post=853"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}