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

List out the differences between the clustered index and non-clustered index in sql server?

1006


What are the types of database schema? : sql server analysis services, ssas

1134


how many layers of tcp/ip protocol combined of? : Sql server database administration

997


What are triggers in ms sql server?

1162


What is advantage data architect?

924


Explain the relational database management system (rdbms)?

1098


What is the difference between resultset and resultsetmetadata?

971


What is bookmark link in ssrs?

244


Explain the properties of the relational tables?

996


What is filter index?

951


How do I find query history in sql server?

944


Name 3 ways to get an accurate count of the number of records in a table?

1039


Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?

948


What does it mean if @@cursor_row returns a negative number?

992


How can you tell if a database object is invalid?

1074