{"id":201875,"date":"2023-12-17T10:59:53","date_gmt":"2023-12-17T10:59:53","guid":{"rendered":"https:\/\/namso-gen.co\/blog\/how-to-get-last-inserted-identity-value-in-sql-server\/"},"modified":"2023-12-17T10:59:53","modified_gmt":"2023-12-17T10:59:53","slug":"how-to-get-last-inserted-identity-value-in-sql-server","status":"publish","type":"post","link":"https:\/\/namso-gen.co\/blog\/how-to-get-last-inserted-identity-value-in-sql-server\/","title":{"rendered":"How to get last inserted identity value in SQL Server?"},"content":{"rendered":"<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-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-last-inserted-identity-value-in-sql-server\/#How_to_Get_Last_Inserted_Identity_Value_in_SQL_Server\" title=\"How to Get Last Inserted Identity Value in SQL Server?\">How to Get Last Inserted Identity Value in SQL Server?<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-last-inserted-identity-value-in-sql-server\/#What_is_the_difference_between_SCOPE_IDENTITY_IDENTITY_and_IDENT_CURRENT_functions\" title=\"What is the difference between SCOPE_IDENTITY(), @@IDENTITY, and IDENT_CURRENT() functions?\">What is the difference between SCOPE_IDENTITY(), @@IDENTITY, and IDENT_CURRENT() functions?<\/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-inserted-identity-value-in-sql-server\/#Is_it_recommended_to_use_SCOPE_IDENTITY_over_IDENTITY_or_IDENT_CURRENT\" title=\"Is it recommended to use SCOPE_IDENTITY() over @@IDENTITY or IDENT_CURRENT()?\">Is it recommended to use SCOPE_IDENTITY() over @@IDENTITY or IDENT_CURRENT()?<\/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-inserted-identity-value-in-sql-server\/#Can_SCOPE_IDENTITY_be_used_with_triggers\" title=\"Can SCOPE_IDENTITY() be used with triggers?\">Can SCOPE_IDENTITY() be used with triggers?<\/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-inserted-identity-value-in-sql-server\/#Can_I_use_SCOPE_IDENTITY_if_there_are_multiple_INSERT_operations_in_the_same_batch\" title=\"Can I use SCOPE_IDENTITY() if there are multiple INSERT operations in the same batch?\">Can I use SCOPE_IDENTITY() if there are multiple INSERT operations in the same batch?<\/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-inserted-identity-value-in-sql-server\/#Is_SCOPE_IDENTITY_session-specific\" title=\"Is SCOPE_IDENTITY() session-specific?\">Is SCOPE_IDENTITY() session-specific?<\/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-inserted-identity-value-in-sql-server\/#Can_I_use_SCOPE_IDENTITY_with_temporary_tables\" title=\"Can I use SCOPE_IDENTITY() with temporary tables?\">Can I use SCOPE_IDENTITY() with temporary tables?<\/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-inserted-identity-value-in-sql-server\/#Does_SCOPE_IDENTITY_work_with_tables_without_an_identity_column\" title=\"Does SCOPE_IDENTITY() work with tables without an identity column?\">Does SCOPE_IDENTITY() work with tables without an identity column?<\/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-inserted-identity-value-in-sql-server\/#Can_I_use_SCOPE_IDENTITY_in_a_stored_procedure\" title=\"Can I use SCOPE_IDENTITY() in a stored procedure?\">Can I use SCOPE_IDENTITY() in a stored procedure?<\/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-inserted-identity-value-in-sql-server\/#Is_there_any_performance_impact_of_using_SCOPE_IDENTITY\" title=\"Is there any performance impact of using SCOPE_IDENTITY()?\">Is there any performance impact of using 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-inserted-identity-value-in-sql-server\/#Can_SCOPE_IDENTITY_be_used_with_OUTPUT_clause\" title=\"Can SCOPE_IDENTITY() be used with OUTPUT clause?\">Can SCOPE_IDENTITY() be used with OUTPUT clause?<\/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-inserted-identity-value-in-sql-server\/#Does_SCOPE_IDENTITY_return_the_correct_identity_value_in_all_scenarios\" title=\"Does SCOPE_IDENTITY() return the correct identity value in all scenarios?\">Does SCOPE_IDENTITY() return the correct identity value in all scenarios?<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"How_to_Get_Last_Inserted_Identity_Value_in_SQL_Server\"><\/span>How to Get Last Inserted Identity Value in SQL Server?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Getting the last inserted identity value in SQL Server can be useful in many scenarios, such as when you need to retrieve the primary key of a newly inserted record. To accomplish this, you can use the `SCOPE_IDENTITY()` function, which returns the last identity value generated for any table in the current session and the current scope. This method is safer and more reliable than using `@@IDENTITY` or `IDENT_CURRENT()` functions because it ensures you are retrieving the correct identity value.<\/p>\n<p>&#8220;`sql<br \/>\nINSERT INTO TableName (ColumnName) VALUES (&#8216;Value&#8217;);<br \/>\nSELECT SCOPE_IDENTITY();<br \/>\n&#8220;`<\/p>\n<p>By executing the `SELECT SCOPE_IDENTITY();` statement immediately after an INSERT operation, you can retrieve the last inserted identity value in SQL Server.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"What_is_the_difference_between_SCOPE_IDENTITY_IDENTITY_and_IDENT_CURRENT_functions\"><\/span>What is the difference between SCOPE_IDENTITY(), @@IDENTITY, and IDENT_CURRENT() functions?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>`SCOPE_IDENTITY()`: Returns the last identity value generated for any table in the current session and scope.<br \/>\n`@@IDENTITY`: Returns the last identity value generated for any table in the current session, regardless of the scope.<br \/>\n`IDENT_CURRENT(&#8216;TableName&#8217;)`: Returns the last identity value generated for a specific table.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Is_it_recommended_to_use_SCOPE_IDENTITY_over_IDENTITY_or_IDENT_CURRENT\"><\/span>Is it recommended to use SCOPE_IDENTITY() over @@IDENTITY or IDENT_CURRENT()?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Yes, it is recommended to use `SCOPE_IDENTITY()` over `@@IDENTITY` or `IDENT_CURRENT()` because it provides a more reliable and safer way to retrieve the last inserted identity value.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Can_SCOPE_IDENTITY_be_used_with_triggers\"><\/span>Can SCOPE_IDENTITY() be used with triggers?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Yes, `SCOPE_IDENTITY()` can be used within triggers to retrieve the last inserted identity value within the trigger&#8217;s scope.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Can_I_use_SCOPE_IDENTITY_if_there_are_multiple_INSERT_operations_in_the_same_batch\"><\/span>Can I use SCOPE_IDENTITY() if there are multiple INSERT operations in the same batch?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Yes, SCOPE_IDENTITY() will always return the last identity value generated within the current scope, even if there are multiple INSERT operations in the same batch.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Is_SCOPE_IDENTITY_session-specific\"><\/span>Is SCOPE_IDENTITY() session-specific?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Yes, SCOPE_IDENTITY() is session-specific and will only return the last identity value generated in the current session.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Can_I_use_SCOPE_IDENTITY_with_temporary_tables\"><\/span>Can I use SCOPE_IDENTITY() with temporary tables?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Yes, SCOPE_IDENTITY() can be used with temporary tables to retrieve the last inserted identity value within the current session and scope.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Does_SCOPE_IDENTITY_work_with_tables_without_an_identity_column\"><\/span>Does SCOPE_IDENTITY() work with tables without an identity column?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>No, SCOPE_IDENTITY() is specifically designed to retrieve the last inserted identity value from a table with an identity column.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Can_I_use_SCOPE_IDENTITY_in_a_stored_procedure\"><\/span>Can I use SCOPE_IDENTITY() in a stored procedure?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Yes, SCOPE_IDENTITY() can be used within a stored procedure to retrieve the last inserted identity value within the scope of the procedure.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Is_there_any_performance_impact_of_using_SCOPE_IDENTITY\"><\/span>Is there any performance impact of using SCOPE_IDENTITY()?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>There is minimal performance impact of using SCOPE_IDENTITY() compared to other methods, making it a reliable and efficient way to retrieve the last inserted identity value.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Can_SCOPE_IDENTITY_be_used_with_OUTPUT_clause\"><\/span>Can SCOPE_IDENTITY() be used with OUTPUT clause?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Yes, SCOPE_IDENTITY() can be used with the OUTPUT clause to retrieve the last inserted identity value along with other inserted values.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Does_SCOPE_IDENTITY_return_the_correct_identity_value_in_all_scenarios\"><\/span>Does SCOPE_IDENTITY() return the correct identity value in all scenarios?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Yes, SCOPE_IDENTITY() ensures that you are retrieving the correct identity value for the last inserted record in SQL Server, making it a safe and reliable choice for such operations. <\/p>\n<p>In conclusion, using the `SCOPE_IDENTITY()` function is the recommended way to retrieve the last inserted identity value in SQL Server. This method is reliable, safe, and efficient, making it the ideal choice for retrieving primary keys of newly inserted records in your database.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>How to Get Last Inserted Identity Value in SQL Server? Getting the last inserted identity value in SQL Server can be useful in many scenarios, such as when you need to retrieve the primary key of a newly inserted record. To accomplish this, you can use the `SCOPE_IDENTITY()` function, which returns the last identity value &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to get last inserted identity value in SQL Server?\" class=\"read-more button\" href=\"https:\/\/namso-gen.co\/blog\/how-to-get-last-inserted-identity-value-in-sql-server\/#more-201875\">Read more<span class=\"screen-reader-text\">How to get last inserted 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-201875","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 inserted identity value in SQL Server?<\/title>\n<meta name=\"description\" content=\"How to Get Last Inserted Identity Value in SQL Server? Getting the last inserted identity value in SQL Server can be useful in many scenarios, such as\" \/>\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-inserted-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 inserted identity value in SQL Server?\" \/>\n<meta property=\"og:description\" content=\"How to Get Last Inserted Identity Value in SQL Server? Getting the last inserted identity value in SQL Server can be useful in many scenarios, such as\" \/>\n<meta property=\"og:url\" content=\"https:\/\/namso-gen.co\/blog\/how-to-get-last-inserted-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-17T10:59:53+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=\"3 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-inserted-identity-value-in-sql-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-get-last-inserted-identity-value-in-sql-server\/\"},\"author\":{\"name\":\"Adam Forbes\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/88cd882dfb29a6b147bc0ea26dc84060\"},\"headline\":\"How to get last inserted identity value in SQL Server?\",\"datePublished\":\"2023-12-17T10:59:53+00:00\",\"dateModified\":\"2023-12-17T10:59:53+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-get-last-inserted-identity-value-in-sql-server\/\"},\"wordCount\":568,\"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-inserted-identity-value-in-sql-server\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-get-last-inserted-identity-value-in-sql-server\/\",\"url\":\"https:\/\/namso-gen.co\/blog\/how-to-get-last-inserted-identity-value-in-sql-server\/\",\"name\":\"How to get last inserted identity value in SQL Server?\",\"isPartOf\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#website\"},\"datePublished\":\"2023-12-17T10:59:53+00:00\",\"dateModified\":\"2023-12-17T10:59:53+00:00\",\"description\":\"How to Get Last Inserted Identity Value in SQL Server? Getting the last inserted identity value in SQL Server can be useful in many scenarios, such as\",\"breadcrumb\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-get-last-inserted-identity-value-in-sql-server\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/namso-gen.co\/blog\/how-to-get-last-inserted-identity-value-in-sql-server\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-get-last-inserted-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 inserted 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 inserted identity value in SQL Server?","description":"How to Get Last Inserted Identity Value in SQL Server? Getting the last inserted identity value in SQL Server can be useful in many scenarios, such as","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-inserted-identity-value-in-sql-server\/","og_locale":"en_US","og_type":"article","og_title":"How to get last inserted identity value in SQL Server?","og_description":"How to Get Last Inserted Identity Value in SQL Server? Getting the last inserted identity value in SQL Server can be useful in many scenarios, such as","og_url":"https:\/\/namso-gen.co\/blog\/how-to-get-last-inserted-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-17T10:59:53+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":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/namso-gen.co\/blog\/how-to-get-last-inserted-identity-value-in-sql-server\/#article","isPartOf":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-get-last-inserted-identity-value-in-sql-server\/"},"author":{"name":"Adam Forbes","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/88cd882dfb29a6b147bc0ea26dc84060"},"headline":"How to get last inserted identity value in SQL Server?","datePublished":"2023-12-17T10:59:53+00:00","dateModified":"2023-12-17T10:59:53+00:00","mainEntityOfPage":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-get-last-inserted-identity-value-in-sql-server\/"},"wordCount":568,"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-inserted-identity-value-in-sql-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/namso-gen.co\/blog\/how-to-get-last-inserted-identity-value-in-sql-server\/","url":"https:\/\/namso-gen.co\/blog\/how-to-get-last-inserted-identity-value-in-sql-server\/","name":"How to get last inserted identity value in SQL Server?","isPartOf":{"@id":"https:\/\/namso-gen.co\/blog\/#website"},"datePublished":"2023-12-17T10:59:53+00:00","dateModified":"2023-12-17T10:59:53+00:00","description":"How to Get Last Inserted Identity Value in SQL Server? Getting the last inserted identity value in SQL Server can be useful in many scenarios, such as","breadcrumb":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-get-last-inserted-identity-value-in-sql-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/namso-gen.co\/blog\/how-to-get-last-inserted-identity-value-in-sql-server\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/namso-gen.co\/blog\/how-to-get-last-inserted-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 inserted 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\/201875","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=201875"}],"version-history":[{"count":0,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/posts\/201875\/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=201875"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/categories?post=201875"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/tags?post=201875"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}