Skip to content
September 26, 2023
  • Subscribe
  • Twitter
  • LinkedIN Group (Forum)
  • Facebook Group (Forum)
  • Facebook Page
  • YouTube
  • Telegram Group (Forum)
SQLServerGeeks

SQLServerGeeks

SQL Server Education (by the geeks, for the geeks)

Free Live Event Free Live Training Virtual Symposium DPD banglore
  • Free Courses
  • Blogs
    • Subscribe To Our Newsletter
    • SQLServerGeeks Bulletin Index
    • The Scripts Garage
    • All Blog Posts
    • One DMV a Day Series
    • Accidental DBA Series
    • One Operator a Day Series
    • One Trace Flag a Day Series
  • Magazine
  • Events
    • Browse Events
    • Suggest Topics
  • Videos
    • SSG Videos Lobby
    • Premium Content (SQLMaestros)
    • SQL Server Tutorials & Demos
    • Webinar Recordings
    • SQLShighra Recordings
    • Virtual Symposium Recordings
      • SQL Server & Azure SQL – May 2021
      • SQL Server 2019 & Azure SQL – May 2020
    • Geek Talks
  • RESOURCES
    • SQL Server Resources
    • SQL Server Notes by Amit Bansal (AB)
  • About Us
    • Subscribe To Our Newsletter
    • Social Channels
    • SSG Team
    • Join Us
    • Speakers
    • Blog With Us
    • Contact Us
    • Write a Guest Post
    • Testimonials
    • Join DataPlatformGeeks community
  • Log In
  • Join Now
Main Menu

Tag: Identity

SQL Server

SQL SERVER 2017 – IDENTITY_CACHE

September 25, 2017November 7, 2017 - by Sandip Pani - Leave a Comment

When we define a table with Identity column, SQL Server might cache the identity values to improve performance. Due to server restart or database failure some assigned values may be lost.  …

SQL SERVER 2017 – IDENTITY_CACHE Read More
SQL Server

Identity Property Part – 3

July 23, 2016October 26, 2016 - by Sandip Pani - Leave a Comment

This is the third part of this blog series. You can read the 2nd part here Here. In this blog post we’ll learn how to retrieve last generated identity value. There are scenarios where …

Identity Property Part – 3 Read More
SQL Server / SQL Server Accidental DBA Series

SQL Server error code 544 – Cannot insert explicit value for identity column

January 10, 2015December 20, 2019 - by SQL Geek - Leave a Comment

The SQL Server error code 544 – Cannot insert explicit value for identity column, occurs when one tries to insert an explicit value for an identity column and identity_insert is off …

SQL Server error code 544 – Cannot insert explicit value for identity column Read More
SQL Server / SQL Server Accidental DBA Series

IDENT_CURRENT vs SCOPE_IDENTITY vs @@IDENTITY vs. IDENTITY in SQL Server

November 17, 2014December 20, 2019 - by SQL Geek - Leave a Comment

These are the most common functions to work with identity values in SQL Server. This blog looks at IDENT_CURRENT vs. SCOPE_IDENTITY vs. @@IDENTITY vs. IDENTITY comparison. Let’s look at the definition …

IDENT_CURRENT vs SCOPE_IDENTITY vs @@IDENTITY vs. IDENTITY in SQL Server Read More
SQL Server

What is IDENTITY_INSERT?

May 8, 2013April 25, 2018 - by Piyush Bajaj - 15 Comments.

Hi Folks, What is IDENTITY_INSERT? I am sure that all of you would be aware about the role of Identity column in a table, i.e., it is column which keeps on …

What is IDENTITY_INSERT? Read More

Looking for Premium SQL Content?
Check out advanced SQL tutorials
on SQLMaestros


Subscribe to SQLServerGeeks

Free Live Event


Ad

Virtual Symposium

master classes



SSG_linkedin

SSG_fb

About Us

  • Core Team
  • Authors
  • Blog With Us
  • Testimonials
  • Contact Us
  • Join DataPlatformGeeks Community

Virtual Symposium

Copyright © 2022 SQLServerGeeks. Community initiative by Amit Bansal | Anti-Harassment Policy
Powered by WordPress and HitMag.