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

SQL stops working in every 15 days displaying message that database log file is full. Log file size is 3.95 GB. It is happening after shrinking the database also. What is solution to overcome this problem. Please help me as it's urgent.

5 Answers  

What is the difference between an index and a unique index?

0 Answers  

How do I list the available tables in a database I'm querying?

4 Answers  

Using the customer, and order table in northwind database, please write a query to produce xml?

0 Answers  

What is the difference between HAVING clause and the WHERE clause?

7 Answers  

What is the filtered index?

0 Answers  

What is the use of tempdb? What values does it hold?

0 Answers   Abacus,

How to insert and update data into a table with "insert" and "update" statements?

0 Answers  

How can I check that whether automatic statistic update is enabled or not?

0 Answers  

You want to implement the one-to-many relationship while designing tables. How would you do it?

0 Answers  

How many types of stored procedures are there in sql server?

0 Answers  

What is Extended user-defined?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories