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 Get the last identity value used

Answer Posted / chandramohan

scope_identity() would be the currect answer. To avoid potential problems professionals suggests this method since it returns the recently added value.

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I know if localdb is running?

928


What do you mean by an execution plan?

1091


How to create a user name in a database?

1030


Are resultset updatable?

925


What is log cache in sql server?

1021


What do you do in data exploration

974


What are the different types of triggers in SQL SERVER?

1105


What is the purpose of data source?

1017


how can you check the level of fragmentation on a table? : Sql server administration

951


Why do we need normalization?

901


What is rs.exe utility?

156


How we can refresh the view?

1095


How many databases instances are there in sql server 2000?

1075


You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?

121


What is meant by referential integrity?

995