SCOPE_IDENTITY()

Question

Hi every one my SCOPE_IDENTITY() is returning wrong value. i'm using sqlserver Please help

Nilesh Shah · Answer

How did you come to the resolution that it returns wrong value? SCOPE_IDENTITY() always returns the last identity value inserted into an identity column in the same scope. When you say it is returning wrong value what were you expecting and what did it return?

Amit Gupta · Answer

Please clarfy the exact problem what is it?

Bryian Tan · Answer

@Lucas Ngobeni Sorry we can't see what on your screen :) You need to provide more information so that c-sharpcorner members can better assists you.