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

Returns the last identity value inserted into an identity
column in the same scope. A scope is a module: a stored
procedure, trigger, function, or batch.

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Do you know what are pages and extents? : SQL Server Architecture

996


What is a livelock?

973


What is the difference between indexing and hashing?

1175


What does dml stand for?

952


What is the data tier application?

169


How do I find the size of a sql server database?

931


How do you delete a data source?

1013


How to copy the tables, schema and views from one sql server to another?

1051


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

1199


Which rendering formats are affected by the pagesize properties?

144


Difference between Sql server reporting services and Crystal reports?

172


which table keeps the locking information? : Sql server administration

1107


Can the “if update (colname)” statement be used in a delete trigger?

994


what is a sub-report?

142


What are the different Topologies in which Replication can be configured?

1185