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

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

What is SCOPE_IDENTITY() in sql

Question Posted / deepthi

Answers were Sorted based on User's Feedback



What is SCOPE_IDENTITY() in sql..

Answer / deepthi

It will return the value of Auto Increment column , for the
newly inserted row value.

Is This Answer Correct ?    35 Yes 3 No

What is SCOPE_IDENTITY() in sql..

Answer / vipul

When new row insert into table its we can get value of auto
increment column using SCOPE_IDENTITY()

Is This Answer Correct ?    10 Yes 2 No

What is SCOPE_IDENTITY() in sql..

Answer / ranjani

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

Is This Answer Correct ?    7 Yes 2 No

What is SCOPE_IDENTITY() in sql..

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

More SQL Server Interview Questions

What is the difference between a function and a stored procedure?

0 Answers  

How to use user defined functions in expressions?

0 Answers  

What is the stuff?

0 Answers  

you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?

0 Answers  

How many types of functions are there in sql server?

0 Answers  

What is the difference between a fill factor of 100 and 0?

0 Answers  

what are constraints? Explain different types of constraints? : Sql server database administration

0 Answers  

What are the different types of indexes?

0 Answers   Blue Star,

Write a query to get all details of employee who has maximum salary from employee table

8 Answers   AON, Genpact,

which database is best to use in oracle and sql server? explain reasons?

5 Answers   TCS,

how to insert the values in 5 table at a time Using any single statement ?

6 Answers   Infosys, Value Labs,

What to check if a User database is locked?

0 Answers   TCS,

For more SQL Server Interview Questions Click Here
Categories