Skip to main content
sql return last inserted id scope identity

SQL Getting Last Inserted Id using SCOPE IDENTITY

SQL server Database as a function ‘SCOPE_IDENTITY()‘ which can be used to return the last created ID or Identity (Auto Incremented Primary Key) by the SQL query statement. This cannot be used in Update statement queries as it returns only last created Identity by the SQL query statement. sql return last inserted id scope identity. Syntax […]

Read More