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...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

How to Get the last identity value used

Question Posted / chandramohan

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 the advantages to use stored procedures?

1031

Explain about merge replications?

963

Explain what are magic tables in sql server?

946

What are the advantages of passing name-value pairs as parameters?

1102

Write a query for primary key constraint with identity key word?

971

Can foreign key be deleted?

870

Explain boyce and codd normal form(bcnf)?

890

How to create an index on an existing table in ms sql server?

918

What are the tables in sql?

1037

How to query multiple tables jointly?

918

What are the mathematical functions supported by sql server 2005?

994

How do I install sql server?

842

Differentiate between SQL and ORACLE joins and write their syntax.

975

Explain the truncate command? : SQL Server Architecture

1091

what's the maximum size of a row? : Sql server database administration

1012