{"id":201464,"date":"2023-10-04T16:55:45","date_gmt":"2023-10-04T16:55:45","guid":{"rendered":"https:\/\/namso-gen.co\/blog\/how-to-get-identity-value-in-sql-server\/"},"modified":"2023-10-04T16:55:45","modified_gmt":"2023-10-04T16:55:45","slug":"how-to-get-identity-value-in-sql-server","status":"publish","type":"post","link":"https:\/\/namso-gen.co\/blog\/how-to-get-identity-value-in-sql-server\/","title":{"rendered":"How to get identity value in SQL Server?"},"content":{"rendered":"<p>Getting the identity value generated by an INSERT statement in SQL Server can be crucial for various operations. The identity value represents a unique identifier for each row in a table, typically generated automatically by the database when a new record is inserted. There are a few methods to retrieve this value in SQL Server, depending on the version of SQL Server you are using.<\/p>\n<p><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_62 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-identity-value-in-sql-server\/#1_How_to_get_identity_value_in_SQL_Server_using_SCOPE_IDENTITY_function\" title=\"1. How to get identity value in SQL Server using SCOPE_IDENTITY() function?\">1. How to get identity value in SQL Server using SCOPE_IDENTITY() function?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-identity-value-in-sql-server\/#2_How_to_get_identity_value_in_SQL_Server_using_IDENTITY_variable\" title=\"2. How to get identity value in SQL Server using @@IDENTITY variable?\">2. How to get identity value in SQL Server using @@IDENTITY variable?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-identity-value-in-sql-server\/#3_How_to_get_identity_value_in_SQL_Server_using_IDENT_CURRENT_function\" title=\"3. How to get identity value in SQL Server using IDENT_CURRENT() function?\">3. How to get identity value in SQL Server using IDENT_CURRENT() function?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-identity-value-in-sql-server\/#4_How_to_get_identity_value_in_SQL_Server_using_OUTPUT_clause\" title=\"4. How to get identity value in SQL Server using OUTPUT clause?\">4. How to get identity value in SQL Server using OUTPUT clause?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-identity-value-in-sql-server\/#5_How_to_get_identity_value_in_SQL_Server_using_INSERT_INTO%E2%80%A6OUTPUT%E2%80%A6VALUES\" title=\"5. How to get identity value in SQL Server using INSERT INTO&#8230;OUTPUT&#8230;VALUES?\">5. How to get identity value in SQL Server using INSERT INTO&#8230;OUTPUT&#8230;VALUES?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-identity-value-in-sql-server\/#6_How_to_get_identity_value_in_SQL_Server_using_ROWCOUNT_variable\" title=\"6. How to get identity value in SQL Server using @@ROWCOUNT variable?\">6. How to get identity value in SQL Server using @@ROWCOUNT variable?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-identity-value-in-sql-server\/#7_How_to_handle_multiple_identity_columns_in_SQL_Server\" title=\"7. How to handle multiple identity columns in SQL Server?\">7. How to handle multiple identity columns in SQL Server?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-identity-value-in-sql-server\/#8_How_to_reset_identity_value_in_SQL_Server\" title=\"8. How to reset identity value in SQL Server?\">8. How to reset identity value in SQL Server?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-identity-value-in-sql-server\/#9_How_to_check_if_a_table_has_an_identity_column_in_SQL_Server\" title=\"9. How to check if a table has an identity column in SQL Server?\">9. How to check if a table has an identity column in SQL Server?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-identity-value-in-sql-server\/#10_How_to_set_a_custom_seed_for_identity_values_in_SQL_Server\" title=\"10. How to set a custom seed for identity values in SQL Server?\">10. How to set a custom seed for identity values in SQL Server?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-identity-value-in-sql-server\/#11_How_to_retrieve_the_identity_value_of_a_specific_row_after_inserting_multiple_rows_in_SQL_Server\" title=\"11. How to retrieve the identity value of a specific row after inserting multiple rows in SQL Server?\">11. How to retrieve the identity value of a specific row after inserting multiple rows in SQL Server?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-identity-value-in-sql-server\/#12_How_to_prevent_identity_value_gaps_in_SQL_Server\" title=\"12. How to prevent identity value gaps in SQL Server?\">12. How to prevent identity value gaps in SQL Server?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-identity-value-in-sql-server\/#13_How_to_handle_identity_value_overflow_in_SQL_Server\" title=\"13. How to handle identity value overflow in SQL Server?\">13. How to handle identity value overflow in SQL Server?<\/a><\/li><\/ul><\/nav><\/div>\n<h3><span class=\"ez-toc-section\" id=\"1_How_to_get_identity_value_in_SQL_Server_using_SCOPE_IDENTITY_function\"><\/span>1. How to get identity value in SQL Server using SCOPE_IDENTITY() function?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><\/p>\n<p>The SCOPE_IDENTITY() function in SQL Server allows you to retrieve the last identity value that was generated within the same scope. This function is commonly used after an INSERT statement to get the identity value of the newly inserted row.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"2_How_to_get_identity_value_in_SQL_Server_using_IDENTITY_variable\"><\/span>2. How to get identity value in SQL Server using @@IDENTITY variable?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><\/p>\n<p>The @@IDENTITY variable in SQL Server is another way to retrieve the last identity value generated, but it has some limitations. It returns the last identity value generated in the current session, which may not always be what you expect.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"3_How_to_get_identity_value_in_SQL_Server_using_IDENT_CURRENT_function\"><\/span>3. How to get identity value in SQL Server using IDENT_CURRENT() function?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><\/p>\n<p>The IDENT_CURRENT() function in SQL Server allows you to retrieve the last identity value generated for a specific table. This can be useful when you want to get the identity value of a table other than the one where the INSERT statement was executed.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"4_How_to_get_identity_value_in_SQL_Server_using_OUTPUT_clause\"><\/span>4. How to get identity value in SQL Server using OUTPUT clause?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><\/p>\n<p>The OUTPUT clause in SQL Server can be used to return the generated identity values along with other columns after an INSERT operation. This allows you to retrieve the identity values in the result set without having to use separate functions or variables.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"5_How_to_get_identity_value_in_SQL_Server_using_INSERT_INTO%E2%80%A6OUTPUT%E2%80%A6VALUES\"><\/span>5. How to get identity value in SQL Server using INSERT INTO&#8230;OUTPUT&#8230;VALUES?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><\/p>\n<p>By using the INSERT INTO&#8230;OUTPUT&#8230;VALUES syntax in SQL Server, you can insert values into a table and return the newly generated identity values in the result set. This can be a convenient way to get the identity values without additional queries or functions.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"6_How_to_get_identity_value_in_SQL_Server_using_ROWCOUNT_variable\"><\/span>6. How to get identity value in SQL Server using @@ROWCOUNT variable?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><\/p>\n<p>The @@ROWCOUNT variable in SQL Server can be used to determine the number of rows affected by the last statement, including INSERT, DELETE, or UPDATE operations. By checking the value of @@ROWCOUNT after an INSERT statement, you can infer the number of identity values generated.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"7_How_to_handle_multiple_identity_columns_in_SQL_Server\"><\/span>7. How to handle multiple identity columns in SQL Server?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><\/p>\n<p>When dealing with tables that have multiple identity columns, it is important to carefully manage the generation of identity values to avoid conflicts. You can use the IDENTITY_INSERT setting to temporarily allow explicit values for identity columns, or consider using a composite key instead.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"8_How_to_reset_identity_value_in_SQL_Server\"><\/span>8. How to reset identity value in SQL Server?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><\/p>\n<p>If you need to reset the identity value for a table in SQL Server, you can use the DBCC CHECKIDENT command. This command allows you to reseed the identity value to a specific number, effectively resetting the counter for new rows.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"9_How_to_check_if_a_table_has_an_identity_column_in_SQL_Server\"><\/span>9. How to check if a table has an identity column in SQL Server?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><\/p>\n<p>You can query the INFORMATION_SCHEMA.COLUMNS view in SQL Server to check if a specific table has an identity column. Look for columns with the IS_IDENTITY property set to &#8216;YES&#8217; to identify identity columns in a table.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"10_How_to_set_a_custom_seed_for_identity_values_in_SQL_Server\"><\/span>10. How to set a custom seed for identity values in SQL Server?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><\/p>\n<p>By using the IDENTITY(seed, increment) property in SQL Server, you can set a custom seed value for identity columns. This allows you to specify the starting point for identity values in a table, along with an increment value for each new row.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"11_How_to_retrieve_the_identity_value_of_a_specific_row_after_inserting_multiple_rows_in_SQL_Server\"><\/span>11. How to retrieve the identity value of a specific row after inserting multiple rows in SQL Server?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><\/p>\n<p>If you need to retrieve the identity value of a specific row after inserting multiple rows in SQL Server, you can use the OUTPUT clause with a WHERE condition to filter the result set. This allows you to identify the identity value of the desired row among the inserted records.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"12_How_to_prevent_identity_value_gaps_in_SQL_Server\"><\/span>12. How to prevent identity value gaps in SQL Server?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><\/p>\n<p>Identity value gaps can occur in SQL Server due to various factors, such as rollbacks, failed inserts, or server restarts. To minimize these gaps, consider using transactions to ensure the successful insertion of records, or use a sequence object for more controlled generation of unique identifiers.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"13_How_to_handle_identity_value_overflow_in_SQL_Server\"><\/span>13. How to handle identity value overflow in SQL Server?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><\/p>\n<p>If the identity value reaches its maximum limit in SQL Server and overflows, it can cause errors or unexpected behavior. To handle this situation, you can reset the identity value to a lower number using DBCC CHECKIDENT, or consider using a larger data type for the identity column.<\/p>\n<p>In conclusion, there are multiple ways to get the identity value in SQL Server, each with its own advantages and limitations. Whether you choose to use functions like SCOPE_IDENTITY(), variables like @@IDENTITY, or clauses like OUTPUT, understanding these methods can help you effectively retrieve and manage identity values in your database operations.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Getting the identity value generated by an INSERT statement in SQL Server can be crucial for various operations. The identity value represents a unique identifier for each row in a table, typically generated automatically by the database when a new record is inserted. There are a few methods to retrieve this value in SQL Server, &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to get identity value in SQL Server?\" class=\"read-more button\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-identity-value-in-sql-server\/#more-201464\">Read more<span class=\"screen-reader-text\">How to get identity value in SQL Server?<\/span><\/a><\/p>\n","protected":false},"author":51,"featured_media":107420,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[86279],"tags":[],"class_list":["post-201464","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-learn","no-featured-image-padding"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to get identity value in SQL Server?<\/title>\n<meta name=\"description\" content=\"Getting the identity value generated by an INSERT statement in SQL Server can be crucial for various operations. The identity value represents a unique\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-identity-value-in-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to get identity value in SQL Server?\" \/>\n<meta property=\"og:description\" content=\"Getting the identity value generated by an INSERT statement in SQL Server can be crucial for various operations. The identity value represents a unique\" \/>\n<meta property=\"og:url\" content=\"https:\/\/namso-gen.co\/blog\/how-to-get-identity-value-in-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Namso Gen Blog - Free Credit Card Generator [100% Valid]\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/synchronyfinancial\" \/>\n<meta property=\"article:published_time\" content=\"2023-10-04T16:55:45+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png\" \/>\n\t<meta property=\"og:image:width\" content=\"500\" \/>\n\t<meta property=\"og:image:height\" content=\"164\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Adam Forbes\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@synchrony\" \/>\n<meta name=\"twitter:site\" content=\"@synchrony\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Adam Forbes\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-get-identity-value-in-sql-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-get-identity-value-in-sql-server\/\"},\"author\":{\"name\":\"Adam Forbes\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/88cd882dfb29a6b147bc0ea26dc84060\"},\"headline\":\"How to get identity value in SQL Server?\",\"datePublished\":\"2023-10-04T16:55:45+00:00\",\"dateModified\":\"2023-10-04T16:55:45+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-get-identity-value-in-sql-server\/\"},\"wordCount\":844,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#organization\"},\"articleSection\":[\"Learn\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/namso-gen.co\/blog\/how-to-get-identity-value-in-sql-server\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-get-identity-value-in-sql-server\/\",\"url\":\"https:\/\/namso-gen.co\/blog\/how-to-get-identity-value-in-sql-server\/\",\"name\":\"How to get identity value in SQL Server?\",\"isPartOf\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#website\"},\"datePublished\":\"2023-10-04T16:55:45+00:00\",\"dateModified\":\"2023-10-04T16:55:45+00:00\",\"description\":\"Getting the identity value generated by an INSERT statement in SQL Server can be crucial for various operations. The identity value represents a unique\",\"breadcrumb\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-get-identity-value-in-sql-server\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/namso-gen.co\/blog\/how-to-get-identity-value-in-sql-server\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-get-identity-value-in-sql-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/namso-gen.co\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to get identity value in SQL Server?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#website\",\"url\":\"https:\/\/namso-gen.co\/blog\/\",\"name\":\"Namso Gen Blog - Free Credit Card Generator [100% Valid]\",\"description\":\"In Namso gen blog you can get many tips regarding to Credit cards, VCC, Credit card security etc. You can generate credit cards by using Namso-gen.co\",\"publisher\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/namso-gen.co\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#organization\",\"name\":\"Namso Gen Blog - Free Credit Card Generator [100% Valid]\",\"url\":\"https:\/\/namso-gen.co\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png\",\"contentUrl\":\"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png\",\"width\":500,\"height\":164,\"caption\":\"Namso Gen Blog - Free Credit Card Generator [100% Valid]\"},\"image\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/synchronyfinancial\",\"https:\/\/twitter.com\/synchrony\",\"https:\/\/www.youtube.com\/synchronyfinancial\",\"https:\/\/www.instagram.com\/synchrony\",\"https:\/\/www.linkedin.com\/company\/synchrony-financial\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/88cd882dfb29a6b147bc0ea26dc84060\",\"name\":\"Adam Forbes\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g\",\"caption\":\"Adam Forbes\"},\"description\":\"Guest author Adam Forbes has meticulously crafted and revised this article to the best of their knowledge and understanding. Readers are strongly advised to exercise caution, verify information independently, and rely on their own judgment when considering the information provided. Read more articles on Namso Gen here.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to get identity value in SQL Server?","description":"Getting the identity value generated by an INSERT statement in SQL Server can be crucial for various operations. The identity value represents a unique","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/namso-gen.co\/blog\/how-to-get-identity-value-in-sql-server\/","og_locale":"en_US","og_type":"article","og_title":"How to get identity value in SQL Server?","og_description":"Getting the identity value generated by an INSERT statement in SQL Server can be crucial for various operations. The identity value represents a unique","og_url":"https:\/\/namso-gen.co\/blog\/how-to-get-identity-value-in-sql-server\/","og_site_name":"Namso Gen Blog - Free Credit Card Generator [100% Valid]","article_publisher":"https:\/\/www.facebook.com\/synchronyfinancial","article_published_time":"2023-10-04T16:55:45+00:00","og_image":[{"width":500,"height":164,"url":"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png","type":"image\/png"}],"author":"Adam Forbes","twitter_card":"summary_large_image","twitter_creator":"@synchrony","twitter_site":"@synchrony","twitter_misc":{"Written by":"Adam Forbes","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/namso-gen.co\/blog\/how-to-get-identity-value-in-sql-server\/#article","isPartOf":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-get-identity-value-in-sql-server\/"},"author":{"name":"Adam Forbes","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/88cd882dfb29a6b147bc0ea26dc84060"},"headline":"How to get identity value in SQL Server?","datePublished":"2023-10-04T16:55:45+00:00","dateModified":"2023-10-04T16:55:45+00:00","mainEntityOfPage":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-get-identity-value-in-sql-server\/"},"wordCount":844,"commentCount":0,"publisher":{"@id":"https:\/\/namso-gen.co\/blog\/#organization"},"articleSection":["Learn"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/namso-gen.co\/blog\/how-to-get-identity-value-in-sql-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/namso-gen.co\/blog\/how-to-get-identity-value-in-sql-server\/","url":"https:\/\/namso-gen.co\/blog\/how-to-get-identity-value-in-sql-server\/","name":"How to get identity value in SQL Server?","isPartOf":{"@id":"https:\/\/namso-gen.co\/blog\/#website"},"datePublished":"2023-10-04T16:55:45+00:00","dateModified":"2023-10-04T16:55:45+00:00","description":"Getting the identity value generated by an INSERT statement in SQL Server can be crucial for various operations. The identity value represents a unique","breadcrumb":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-get-identity-value-in-sql-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/namso-gen.co\/blog\/how-to-get-identity-value-in-sql-server\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/namso-gen.co\/blog\/how-to-get-identity-value-in-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/namso-gen.co\/blog\/"},{"@type":"ListItem","position":2,"name":"How to get identity value in SQL Server?"}]},{"@type":"WebSite","@id":"https:\/\/namso-gen.co\/blog\/#website","url":"https:\/\/namso-gen.co\/blog\/","name":"Namso Gen Blog - Free Credit Card Generator [100% Valid]","description":"In Namso gen blog you can get many tips regarding to Credit cards, VCC, Credit card security etc. You can generate credit cards by using Namso-gen.co","publisher":{"@id":"https:\/\/namso-gen.co\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/namso-gen.co\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/namso-gen.co\/blog\/#organization","name":"Namso Gen Blog - Free Credit Card Generator [100% Valid]","url":"https:\/\/namso-gen.co\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png","contentUrl":"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png","width":500,"height":164,"caption":"Namso Gen Blog - Free Credit Card Generator [100% Valid]"},"image":{"@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/synchronyfinancial","https:\/\/twitter.com\/synchrony","https:\/\/www.youtube.com\/synchronyfinancial","https:\/\/www.instagram.com\/synchrony","https:\/\/www.linkedin.com\/company\/synchrony-financial"]},{"@type":"Person","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/88cd882dfb29a6b147bc0ea26dc84060","name":"Adam Forbes","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g","caption":"Adam Forbes"},"description":"Guest author Adam Forbes has meticulously crafted and revised this article to the best of their knowledge and understanding. Readers are strongly advised to exercise caution, verify information independently, and rely on their own judgment when considering the information provided. Read more articles on Namso Gen here."}]}},"_links":{"self":[{"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/posts\/201464","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/users\/51"}],"replies":[{"embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/comments?post=201464"}],"version-history":[{"count":0,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/posts\/201464\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/media\/107420"}],"wp:attachment":[{"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/media?parent=201464"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/categories?post=201464"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/tags?post=201464"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}