... B but SCOPE_IDENTITY will give you the identity from table A (which most likely is... in between your insert and getting @@IDENTITY, you will get the value of the... your insert and your retrieving the identity value. Technically, this is a weak ... values inserted only within the current scope; @@IDENTITY is not limited to a specific scope.- Hide quoted text - - Show quoted text -...

Hi, i don't understand what one means with "current scope". Can someone give me a example in order to understand the difference between both? Thanks Bob SCOPE_IDENTITY returns values inserted only within the current scope; @@IDENTITY is not limited to a specific scope.

...u ovom threadu navedene) metode imaju mogucnost da u nekim situacijama vrate krivi ID. Umjesto Identity stavio sam Scope_Identity jer ima vise korisnika pa ako jos neko unese neki slog, onda ce vratitti krivi ID. Pretpostavljam da ce scope identity vratiti tocno onaj ID od onog recorda koji je unio taj korisnik u tom trenutku, zar ne?

...u ovom threadu navedene) metode imaju mogucnost da u nekim situacijama vrate krivi ID. Umjesto Identity stavio sam Scope_Identity jer ima vise korisnika pa ako jos neko unese neki slog, onda ce vratitti krivi ID. Pretpostavljam da ce scope identity vratiti tocno onaj ID od onog recorda koji je unio taj korisnik u tom trenutku, zar ne?