Interested to Buy Any Domain ? << Click Here >> for more details...
how to rest identity columns in sql server
- 3 Answers
- 12351 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 use of sign function?
What is the difference between set and select?
What is global temp table?
What is a View ? Can we insert, Update and delete a view?
What is self contained sub query?
How except clause is differs from not in clause?
How to send email from database?
What are the different types of normalization?
What are constraints in microsoft sql server?
What is difference between join and natural join?
what kind of lan types do you know? : Sql server database administration
How can sql server instances be hidden?
What is the purpose of the master database?
What is temporary stored procedure?
How do I know if localdb is running?
