Ankur Jain
What is the difference between scope_identity() and current_identity()?
By Ankur Jain in Databases & DBA on Aug 18 2014
  • Rahul Sharma
    Oct, 2016 19

    both will return last inserted value in table but scope_identity is limited to current scope and current session and current_identity is limited to current scope but not limited to current session

    • 0
  • Kml Surani
    May, 2015 13

    http://www.mindfiresolutions.com/Difference-between-IDENTITY-SCOPEIDENTITY-and-IDENTCURRENT-in-SQL-SERVER--1177.php

    • 0
  • Ankur Jain
    Aug, 2014 18

    Scope_identity and current _identity both are similar and it will return the last identity value generated in the table. Scope_Identity will return the identity value in table that is currently in scope

    • 0


Most Popular Job Functions


MOST LIKED QUESTIONS