{"id":201871,"date":"2023-12-15T02:49:30","date_gmt":"2023-12-15T02:49:30","guid":{"rendered":"https:\/\/namso-gen.co\/blog\/how-to-get-last-identity-value-in-sql-server\/"},"modified":"2023-12-15T02:49:30","modified_gmt":"2023-12-15T02:49:30","slug":"how-to-get-last-identity-value-in-sql-server","status":"publish","type":"post","link":"https:\/\/namso-gen.co\/blog\/how-to-get-last-identity-value-in-sql-server\/","title":{"rendered":"How to get last identity value in SQL Server?"},"content":{"rendered":"<p>Retrieving the last identity value that was generated in a table in SQL Server can be useful when you need to know the specific value that was just inserted. There are a few ways to accomplish this task, and below, we will explore some common methods.<\/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-last-identity-value-in-sql-server\/#How_to_get_last_identity_value_in_SQL_Server\" title=\"How to get last identity value in SQL Server?\">How to get last 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-2\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-last-identity-value-in-sql-server\/#What_are_other_ways_to_get_the_last_identity_value_in_SQL_Server\" title=\"What are other ways to get the last identity value in SQL Server?\">What are other ways to get the last 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-3\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-last-identity-value-in-sql-server\/#What_is_the_difference_between_IDENTITY_and_SCOPE_IDENTITY\" title=\"What is the difference between @@IDENTITY and SCOPE_IDENTITY()?\">What is the difference between @@IDENTITY and SCOPE_IDENTITY()?<\/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-last-identity-value-in-sql-server\/#When_should_I_use_SCOPE_IDENTITY_instead_of_IDENTITY\" title=\"When should I use SCOPE_IDENTITY() instead of @@IDENTITY?\">When should I use SCOPE_IDENTITY() instead of @@IDENTITY?<\/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-last-identity-value-in-sql-server\/#What_is_the_purpose_of_the_IDENT_CURRENT_function\" title=\"What is the purpose of the IDENT_CURRENT() function?\">What is the purpose of the IDENT_CURRENT() function?<\/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-last-identity-value-in-sql-server\/#Can_I_use_the_IDENT_CURRENT_function_to_get_the_last_identity_value_in_the_current_session\" title=\"Can I use the IDENT_CURRENT() function to get the last identity value in the current session?\">Can I use the IDENT_CURRENT() function to get the last identity value in the current session?<\/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-last-identity-value-in-sql-server\/#Is_it_possible_to_get_the_last_identity_value_without_inserting_a_new_record\" title=\"Is it possible to get the last identity value without inserting a new record?\">Is it possible to get the last identity value without inserting a new record?<\/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-last-identity-value-in-sql-server\/#How_can_I_use_the_DBCC_CHECKIDENT_command_to_get_the_last_identity_value\" title=\"How can I use the DBCC CHECKIDENT command to get the last identity value?\">How can I use the DBCC CHECKIDENT command to get the last identity value?<\/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-last-identity-value-in-sql-server\/#Can_I_get_the_last_identity_value_for_a_table_in_a_different_database\" title=\"Can I get the last identity value for a table in a different database?\">Can I get the last identity value for a table in a different database?<\/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-last-identity-value-in-sql-server\/#Is_there_a_performance_difference_between_using_IDENTITY_and_SCOPE_IDENTITY\" title=\"Is there a performance difference between using @@IDENTITY and SCOPE_IDENTITY()?\">Is there a performance difference between using @@IDENTITY and SCOPE_IDENTITY()?<\/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-last-identity-value-in-sql-server\/#Can_I_retrieve_the_last_identity_value_generated_by_a_specific_insert_statement\" title=\"Can I retrieve the last identity value generated by a specific insert statement?\">Can I retrieve the last identity value generated by a specific insert statement?<\/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-last-identity-value-in-sql-server\/#Is_it_recommended_to_store_the_last_identity_value_in_a_variable_for_future_use\" title=\"Is it recommended to store the last identity value in a variable for future use?\">Is it recommended to store the last identity value in a variable for future use?<\/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-last-identity-value-in-sql-server\/#Can_I_reset_the_identity_value_after_retrieving_the_last_identity_value\" title=\"Can I reset the identity value after retrieving the last identity value?\">Can I reset the identity value after retrieving the last identity value?<\/a><\/li><\/ul><\/nav><\/div>\n<h3><span class=\"ez-toc-section\" id=\"How_to_get_last_identity_value_in_SQL_Server\"><\/span>How to get last identity value in SQL Server?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>**To get the last identity value in SQL Server, you can use the @@IDENTITY system function. This function returns the last identity value that was generated by any insert statement in the current session.**<\/p>\n<p>Here is an example of how you can use the @@IDENTITY function:<\/p>\n<p>&#8220;`<br \/>\nINSERT INTO TableName (Column1, Column2)<br \/>\nVALUES (&#8216;Value1&#8217;, &#8216;Value2&#8217;);<\/p>\n<p>SELECT @@IDENTITY AS LastIdentityValue;<br \/>\n&#8220;`<\/p>\n<p>This query will insert a new record into the TableName table and then retrieve the last identity value that was generated as a result of that insertion.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"What_are_other_ways_to_get_the_last_identity_value_in_SQL_Server\"><\/span>What are other ways to get the last identity value in SQL Server?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>In addition to using the @@IDENTITY function, you can also use the SCOPE_IDENTITY() and IDENT_CURRENT() functions to retrieve the last identity value in SQL Server.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"What_is_the_difference_between_IDENTITY_and_SCOPE_IDENTITY\"><\/span>What is the difference between @@IDENTITY and SCOPE_IDENTITY()?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>The main difference between @@IDENTITY and SCOPE_IDENTITY() is that @@IDENTITY returns the last identity value generated in any insert statement in the current session, while SCOPE_IDENTITY() returns the last identity value generated in the current scope.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"When_should_I_use_SCOPE_IDENTITY_instead_of_IDENTITY\"><\/span>When should I use SCOPE_IDENTITY() instead of @@IDENTITY?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>If your code contains triggers or stored procedures that perform additional insertions, updates, or deletions after your initial insert statement, it is recommended to use SCOPE_IDENTITY() to ensure that you are getting the correct last identity value.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"What_is_the_purpose_of_the_IDENT_CURRENT_function\"><\/span>What is the purpose of the IDENT_CURRENT() function?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>The IDENT_CURRENT() function is used to retrieve the last identity value for a specific table in SQL Server. This function takes the name of the table as a parameter and returns the last identity value that was generated for that table.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Can_I_use_the_IDENT_CURRENT_function_to_get_the_last_identity_value_in_the_current_session\"><\/span>Can I use the IDENT_CURRENT() function to get the last identity value in the current session?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>No, the IDENT_CURRENT() function is used to retrieve the last identity value for a specific table, not the last identity value generated in the current session. To get the last identity value for the current session, you should use the @@IDENTITY or SCOPE_IDENTITY() function instead.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Is_it_possible_to_get_the_last_identity_value_without_inserting_a_new_record\"><\/span>Is it possible to get the last identity value without inserting a new record?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Yes, you can retrieve the last identity value without actually inserting a new record by using the DBCC CHECKIDENT command. This command allows you to check the current identity value for a table without modifying any data.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"How_can_I_use_the_DBCC_CHECKIDENT_command_to_get_the_last_identity_value\"><\/span>How can I use the DBCC CHECKIDENT command to get the last identity value?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>You can use the following query to get the last identity value using the DBCC CHECKIDENT command:<\/p>\n<p>&#8220;`<br \/>\nDBCC CHECKIDENT (&#8216;TableName&#8217;, NORESEED);<br \/>\n&#8220;`<\/p>\n<p>This command will return the current identity value for the TableName table without resetting the identity value.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Can_I_get_the_last_identity_value_for_a_table_in_a_different_database\"><\/span>Can I get the last identity value for a table in a different database?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Yes, you can specify the name of the table in a different database when using functions like @@IDENTITY, SCOPE_IDENTITY(), or IDENT_CURRENT(). However, you need to ensure that you have the necessary permissions to access the table in the other database.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Is_there_a_performance_difference_between_using_IDENTITY_and_SCOPE_IDENTITY\"><\/span>Is there a performance difference between using @@IDENTITY and SCOPE_IDENTITY()?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>There is generally no significant performance difference between using @@IDENTITY and SCOPE_IDENTITY(). However, SCOPE_IDENTITY() is often preferred in scenarios where you need to ensure that you are getting the correct last identity value in a specific scope.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Can_I_retrieve_the_last_identity_value_generated_by_a_specific_insert_statement\"><\/span>Can I retrieve the last identity value generated by a specific insert statement?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Unfortunately, there is no built-in function in SQL Server that allows you to retrieve the last identity value specifically for a single insert statement. You will need to use one of the system functions like @@IDENTITY, SCOPE_IDENTITY(), or IDENT_CURRENT() to get the last identity value for the current session or scope.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Is_it_recommended_to_store_the_last_identity_value_in_a_variable_for_future_use\"><\/span>Is it recommended to store the last identity value in a variable for future use?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>While it is possible to store the last identity value in a variable for future use, it is generally not recommended unless you have a specific requirement for doing so. It is better to retrieve the last identity value dynamically whenever it is needed to ensure accuracy.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Can_I_reset_the_identity_value_after_retrieving_the_last_identity_value\"><\/span>Can I reset the identity value after retrieving the last identity value?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Yes, you can reset the identity value for a table using the DBCC CHECKIDENT command with the RESEED option. However, you should exercise caution when resetting identity values, as this operation can affect the integrity of your data.<\/p>\n<p>In conclusion, there are several ways to retrieve the last identity value in SQL Server, depending on your specific requirements and the scope of your operations. By using functions like @@IDENTITY, SCOPE_IDENTITY(), and IDENT_CURRENT(), you can easily access the last identity value generated in your database tables.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Retrieving the last identity value that was generated in a table in SQL Server can be useful when you need to know the specific value that was just inserted. There are a few ways to accomplish this task, and below, we will explore some common methods. How to get last identity value in SQL Server? &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to get last identity value in SQL Server?\" class=\"read-more button\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-last-identity-value-in-sql-server\/#more-201871\">Read more<span class=\"screen-reader-text\">How to get last 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-201871","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 last identity value in SQL Server?<\/title>\n<meta name=\"description\" content=\"Retrieving the last identity value that was generated in a table in SQL Server can be useful when you need to know the specific value that was just\" \/>\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-last-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 last identity value in SQL Server?\" \/>\n<meta property=\"og:description\" content=\"Retrieving the last identity value that was generated in a table in SQL Server can be useful when you need to know the specific value that was just\" \/>\n<meta property=\"og:url\" content=\"https:\/\/namso-gen.co\/blog\/how-to-get-last-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-12-15T02:49:30+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-last-identity-value-in-sql-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-get-last-identity-value-in-sql-server\/\"},\"author\":{\"name\":\"Adam Forbes\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/88cd882dfb29a6b147bc0ea26dc84060\"},\"headline\":\"How to get last identity value in SQL Server?\",\"datePublished\":\"2023-12-15T02:49:30+00:00\",\"dateModified\":\"2023-12-15T02:49:30+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-get-last-identity-value-in-sql-server\/\"},\"wordCount\":836,\"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-last-identity-value-in-sql-server\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-get-last-identity-value-in-sql-server\/\",\"url\":\"https:\/\/namso-gen.co\/blog\/how-to-get-last-identity-value-in-sql-server\/\",\"name\":\"How to get last identity value in SQL Server?\",\"isPartOf\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#website\"},\"datePublished\":\"2023-12-15T02:49:30+00:00\",\"dateModified\":\"2023-12-15T02:49:30+00:00\",\"description\":\"Retrieving the last identity value that was generated in a table in SQL Server can be useful when you need to know the specific value that was just\",\"breadcrumb\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-get-last-identity-value-in-sql-server\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/namso-gen.co\/blog\/how-to-get-last-identity-value-in-sql-server\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-get-last-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 last 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 last identity value in SQL Server?","description":"Retrieving the last identity value that was generated in a table in SQL Server can be useful when you need to know the specific value that was just","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-last-identity-value-in-sql-server\/","og_locale":"en_US","og_type":"article","og_title":"How to get last identity value in SQL Server?","og_description":"Retrieving the last identity value that was generated in a table in SQL Server can be useful when you need to know the specific value that was just","og_url":"https:\/\/namso-gen.co\/blog\/how-to-get-last-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-12-15T02:49:30+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-last-identity-value-in-sql-server\/#article","isPartOf":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-get-last-identity-value-in-sql-server\/"},"author":{"name":"Adam Forbes","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/88cd882dfb29a6b147bc0ea26dc84060"},"headline":"How to get last identity value in SQL Server?","datePublished":"2023-12-15T02:49:30+00:00","dateModified":"2023-12-15T02:49:30+00:00","mainEntityOfPage":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-get-last-identity-value-in-sql-server\/"},"wordCount":836,"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-last-identity-value-in-sql-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/namso-gen.co\/blog\/how-to-get-last-identity-value-in-sql-server\/","url":"https:\/\/namso-gen.co\/blog\/how-to-get-last-identity-value-in-sql-server\/","name":"How to get last identity value in SQL Server?","isPartOf":{"@id":"https:\/\/namso-gen.co\/blog\/#website"},"datePublished":"2023-12-15T02:49:30+00:00","dateModified":"2023-12-15T02:49:30+00:00","description":"Retrieving the last identity value that was generated in a table in SQL Server can be useful when you need to know the specific value that was just","breadcrumb":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-get-last-identity-value-in-sql-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/namso-gen.co\/blog\/how-to-get-last-identity-value-in-sql-server\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/namso-gen.co\/blog\/how-to-get-last-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 last 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\/201871","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=201871"}],"version-history":[{"count":0,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/posts\/201871\/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=201871"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/categories?post=201871"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/tags?post=201871"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}