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 preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?

914


What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?

1046


What are the results of running this script?

933


What is the difference between rank and dense_rank?

1090


What is 2nf in normalization?

1003


How to deploy the Report?

138


Does sql server 2016 have ssms?

963


Can you use order by when defining a view?

979


Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication

985


On a windows server 2003 active – passive failover cluster, how do you find the node which is active?

1208


Where actually sql azure database is hosted?

163


What is meant by dirty read?

996


How would you go about developing a ssrs report?

168


What is blocking and how would you troubleshoot it? : sql server database administration

1049


what are candidate key, alternate key and composite key? : Sql server database administration

919