Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

What is the use of sign function?

1124


What is the difference between set and select?

1092


What is global temp table?

994


What is a View ? Can we insert, Update and delete a view?

995


What is self contained sub query?

1054


How except clause is differs from not in clause?

953


How to send email from database?

1013


What are the different types of normalization?

1165


What are constraints in microsoft sql server?

1130


What is difference between join and natural join?

969


what kind of lan types do you know? : Sql server database administration

980


How can sql server instances be hidden?

967


What is the purpose of the master database?

1129


What is temporary stored procedure?

947


How do I know if localdb is running?

952