how to rest identity columns in sql server
Answers were Sorted based on User's Feedback
Answer / muthu kumar
create table t(id int identity(seed,increment))
where seed is starting number and increment is number to be
incremented.
create table t(id int identity(1,1),name varchar(50))
so the id will be start with 1 and will be incremented 1 by
1 each time when record is get insered
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / adhi
USE AdventureWorks;
GO
DBCC CHECKIDENT ("HumanResources.Employee", RESEED, 300);
GO
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / yvbchowdary
The identity is similar to squence object in oracle. syntax
for identity column is
<column-name> <data type> identity(start value,increment)
ex:
empno int identity(100,2)
suppose if u want to add an odd value i.e, 50; u can also
add
first execute IDENTITY_INSERT ON
and then u can insert whatever values u want. then again
execute IDENTITY_INSERT OFF
Is This Answer Correct ? | 0 Yes | 0 No |
what's the difference between a primary key and a unique key? : Sql server database administration
How many types of Cursor in SQL SERVER?
How to check if a table is being used in sql server?
Explain filestream storage of sql server 2008?
Explain the different types of joins?
What are the tables in sql?
Do you have any idea about the tcl commands?
What is the recommended total size of your memory optimized tables?
Can select statements be used on views in ms sql server?
What is the difference between functions and scalar functions?
What specific conditions database should meet, before you can bulk copy data into it using bcp?
How to count rows with the count(*) function in ms sql server?