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

Please give me the SP for the below scenario. I have two tables named Table1 and Table2...I need to fetch record by record from Table1 and insert the record in to table2 where the value in the sno column of the table1 is even number.

4 Answers   Value Labs,

What are the five characteristics of good data?

0 Answers  

What is the difference between value type and reference type?

0 Answers  

How to get the definition of a stored procedure back?

0 Answers  

Which are the new data types introduced in sql server 2008?

0 Answers  

Tell me what is the stuff and how does it differ from the replace function?

0 Answers  

Can a rule be bound to any column of any data type?

0 Answers  

How many types of relations are there between dimension and measure group? : sql server analysis services, ssas

0 Answers  

What are the different types of join?

0 Answers  

Explain the collation?

0 Answers  

Can two tables share the same primary key?

0 Answers  

Explain the concept of recursive stored procedure.

0 Answers  

For more SQL Server Interview Questions Click Here
Categories