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 SCOPE_IDENTITY() in sql

Answer Posted / cow

scope identity will give you the last generated value for
the current session/scope. Note that @@identity is across
sessions.

Is This Answer Correct ?    3 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Where do we use trace frag?

1059


How to enter date and time literals in ms sql server?

1062


How network traffic be reduced by using the stored procedure?

1165


How to download and install microsoft sql server management studio express?

1082


Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

1029


What is the default fill factor value?

1127


Explain trigger and trigger types?

1031


What is the usage of the sign function?

1187


What do you understand by SQL*Net?

1075


State the difference between local and global temporary tables?

1163


What are sql azure firewall rules?

106


How you can get a list of all the table constraints in a database? : Sql server administration

1087


Where in ms sql server is ’100’ equal to ‘0’?

1126


What is the use of “join” in sql server?

1149


Explain what are the basic functions for master, msdb, model, tempdb databases?

1022