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

What is the use of SCOPE_IDENTITY() function?

Question Posted / saravakumar

Answer Posted / saravakumar

Returns the most recently created identity value for the
tables in the current execution scope.

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to connect to a sql server using odbc_connect()?

621

How to list all columns in a table using odbc_columns()?

536

1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?

1555

what is difference between view and Dip.

2001

How to create a simple table to test triggers in ms sql server?

514




Explain syntax for disabling triggers?

526

What are cursors and when they are useful?

577

How to edit table in sql server 2017?

514

What are views in ms sql server?

600

What is the default fill factor value?

584

What are data resources?

506

Explain indexes disadvantages?

551

How to achieve Paging of records in SQL SERVER?

594

Give main differences between "Truncate" and "Delete".

582

How adventureworkslt tables are related?

532