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

What are xml indexes?

1004


Explain timestamp datatype?

1022


Can we do dml on views?

1016


Explain Capacity planning to create a database? and how to monitor it?

4244


what are constraints? : Sql server database administration

1132


Tell me can we use custom code in ssrs?

1054


How to list all user defined functions in the current database?

1119


What are the general features of sql server management studio? : sql server management studio

1135


Which are new data types introduced in sql server 2008?

1106


How do you make a trace?

1074


explain how to create a new schema in a database? : Sql server database administration

1158


What is the difference between stored procedure and functions?

1199


What is the difference between varchar and varchar(max) datatypes?

1134


If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security

1105


Explain aggregate functions?

1141