SQL SERVER – @@IDENTITY vs SCOPE_IDENTITY() vs IDENT_CURRENT – Retrieve Last Inserted Identity of Re

I need to retrieve identity column value from the below query: INSERT INTO table-name(col1, col2) VALUES(val1, val2); SELECT SCOPE_IDENTITY() using C + MS-SQL through ODBC Please find the psuedo code that I have used: hstmt = SQLAllocHandle odbc ...

blog.sqlauthority.com