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

What is the use of SCOPE_IDENTITY() function?

Answer Posted / saravakumar

Returns the most recently created identity value for the
tables in the current execution scope.

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are sql server procedures?

928


Does partitioning improve performance sql server?

896


What is the difference in accessing db between sql server vs sql azure?

174


How self join is different from outer join?

1060


What is the difference between for auto and for nested?

930


What are the restraints imposed on the table design by a merge replication?

981


What is bit data type?

977


What are the steps to take to improve performance of a poor performing query? : sql server database administration

977


What is the difference between count () and rowcount ()?

946


What do you mean by an execution plan? Why is it used? How would you view it?

869


How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?

1137


What are subqueries in sql server?

1062


Explain what is the difference between a local and a global temporary table?

935


Which database stores information about replication?

988


Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.

954