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

Scope_Identity() returns last identity value inserted into
an identity column in the same scope.

Is This Answer Correct ?    7 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to write a query with an inner join in ms sql server?

997


How to return the date part only from a sql server datetime datatype?

1022


List out some of the requirements to set up a sql server failover cluster?

979


What are a database and a data warehouse?

969


Difference between LEN() and DATALENGTH() in sql server ?

1058


how to avoid cursors? : Sql server database administration

904


What is the difference between ddl,dml and dcl commands?

1057


What is user-defined multi-statement table-valued function?

996


What is report snapshot?

142


What is the Control Flow in SSIS

1032


I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

2180


What is the difference between mysql and sql server?

941


What is Extended user-defined?

896


What is the use of sign function?

1034


How to view existing indexes on an given table using sys.indexes?

1036