SQL Identity Archives - Page 3 of 6 - SQL Authority with Pinal Dave

There is an interesting observation when querying the identity column of a table Let us create the following tables CREATE TABLE test1 ( id INT IDENTITY (1,1) ) GO CREATE TABLE test2 ( id INT ) Note that the table test1 has identity column and table test2 does not have…

SQL SERVER – Add Auto Incremental Identity Column to Table After Creating Table

October 11, 2014

SQL Identity, SQL Scripts

Question: Is it possible to add an auto incremental identity column to any table in SQL Server after creating a table. Answer: There are two answers – No and Yes. Let us see them one by one. Answer No – If you have an integer column in your table and…

SQL SERVER – Reset the Identity SEED After ROLLBACK or ERROR

October 8, 2014

I have been blogging for almost 8 years now. I believe I have seen pretty much every single kind of email and comments I can receive from users. However, there are sometimes few which just are so interesting that I feel like blogging about it. This blog post is written…

SQL SERVER – Query to Find Seed Values, Increment Values and Current Identity Column Value of the Table with Max Value of Datatype – Part 2

August 29, 2014

Seven years ago, I wrote a blog post about – Query to Find Seed Values, Increment Values and Current Identity Column value of the table. It is quite a popular blog post and lots of people like it as it gives immediate details about Identity Values. SQL expert Mark Hickin…

SQL SERVER – Query to Find Seed Values, Increment Values and Current Identity Column Value of the Table with Max Value of Datatype

August 27, 2014

SQL SERVER – How to an Add Identity Column to Table in SQL Server

July 27, 2013