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

Explain what is scheduled job and how to create it?

908


What is difference between equi join and inner join?

865


What is nolock hint in sql server 2008

1083


what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration

1068


What authentication modes does sql server support?

1029


How you can get a list of all the table constraints in a database?

918


Do you know the different ddl commands in sql?

1006


Why use “nolock” in sql server?

995


Tell me about normalization in DBMS.

955


Can another user execute your local temporary stored procedures?

946


How to generate random numbers with the rand() function in ms sql server?

1065


What options are available to audit login activity? : sql server security

1105


Explain few examples of stored procedure over triggers?

971


How many categories of data types used by sql server?

977


What is row_number()?

941