how to rest identity columns in sql server
- 3 Answers
- 11184 Views
- Matrix, I also Faced
- E-Mail Answers
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 the difference between a function and a trigger?
Explain the flow of creating a cube? : sql server analysis services, ssas
Explain what is the use of custom fields in report?
What is the bookmark lookup and rid lookup?
what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration
What is the difference between set and select?
Why should we go for stored procedures? Why not direct queries?
What is analysis service repository?
Can we insert data into view sql server?
What are the different types of replication you can set up in sql server?
Can you change the data type of a column in a table after the table has been created? If so, which command would you use?
What is the sql profiler?
What is the contrast amongst drop and truncate?
Can group functions be used in the order by clause in ms sql server?
Explain the categories of stored procedure?
