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 use of except clause? How does it differ from not in clause?
How to assign null values to variables or columns?
What the class forname () does?
What are scheduled tasks in sql server?
what type of index will get created after executing the above statement? : Sql server database administration
Explain the concept of recursive stored procedure.
Explain the properties of sub-query in sql server?
What happens if the update subquery returns no rows in ms sql server?
What are the different types of backups avaialabe in sql server 2005?
What is cursors?
How would you go about developing a ssrs report?
Why do we partition data?
what's the maximum size of a row? : Sql server database administration
What is the difference between ddl and dml?
Can you import Microsoft Excel data to SSRS?