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 is a not null constraint?

1088


How many tables can be joined in SQL Server?

1114


How to download and install microsoft .net framework version 2.0?

1184


Tell me what is the order in which the sql query is executed?

1017


Which tcp/ip port does the sql server run on? How can it be changed?

1114


You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?

1158


If no size is defined while creating the database, what size will the database have?

1036


When you should use a low fill factor?

1036


What are the purposes of floor and sign functions?

1019


You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?

991


How do you manipulate data?

949


What is the purpose of object explorer and its features? : sql server management studio

1276


What is transactional replication?

1022


explain databases and sql server databases architecture? : Sql server database administration

1015


How to create user messages with print statements in ms sql server?

1031