how to rest identity columns in sql server
Answer Posted / 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 |
Post New Answer View All Answers
What is a database table?
What is data mart? : sql server analysis services, ssas
What is database architecture? : SQL Server Architecture
What are indexes in sql?
What is the stored procedure?
How to verify a login name with sqlcmd tool?
Which sql server table is used to hold the stored procedure scripts?
How can we improve performance by using SQL Server profiler?
What is create statement?
What is the difference between functions and scalar functions?
What do you understand by replication in sql server? Mention the different types of replication in sql server.
How does clustered and non clustered index work?
How to get the query of a table in sql server?
How you can change the database name in SQL SERVER?
What are various ways to enhance the ssrs report?