In my previous article I have explained about Convert string to upper,lower and title case using c#.net. In this article I am going to explain about how to set the identity value to a column in a table.
If you want a column in your table to auto increment then you may achieve it using IDENTITY property. Syntax to create a IDENTITY column and a example query is given below.
To get the current identity value of a table below command is used.
To set the value of the identity column to a particular value as per our wish for example 5000,you can use the below command: