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 / guest

the last identity value used in an insert can be retrieved
with the @@identity function.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the main differences between #temp tables and @table variables and which one is preferred?

1013


Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.

971


How do I view views in sql server?

937


What is tabulation?

897


Do you know how to store and query spatial data?

982


Difference between connected and disconnected database in .net with sql server?

1034


what are defaults? Is there a column to which a default can't be bound? : Sql server database administration

1066


What is microsoft sql server?

912


Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?

984


Can sql servers link to other servers like oracle?

789


how do you test proper tcp/ip configuration windows machine? : Sql server database administration

998


Which data type columns are the best candidates for full-text indexing?

917


What is the difference between DataRow.Delete() and DataRow.Remove()?

1166


What is the use of tempdb? What values does it hold?

1002


How to delete duplicate records based on single column from a table?

996