Скачать с ютуб How to get last identity column value using Scope_Identity, Identity and ident_Current. Session 4 в хорошем качестве

How to get last identity column value using Scope_Identity, Identity and ident_Current. Session 4

How to get last identity column value using following methods: • Scope_Identity (): used to get last identity value from column and it works in same session and same scope • @@identity: used to get last identity value from column and it works Same session and across any scope • Ident_current(‘tablename’): used to get last identity value from column and it works for specific table and across any session and any scope --------------------------------------------------------------------------------------------------------------------- select SCOPE_IDENTITY() select @@IDENTITY select IDENT_CURRENT('test3') ---------------------------------------------------------------------------------------------------------------------- create table test3 ( id int identity(1,1), name varchar(20) ) insert into test3 values('mahesh') ----------------------------------------------------------------------------- create table test2 ( id int identity(2,3), name varchar(20) ) insert into test2 values('ashu') ------------------------------------------------------------------------------- create table test1 ( id int , name varchar(20) ) insert into test1 values(1,'mahesh') --------------------------------------------------------------------------------------------------------------------- create trigger trginsert on test2 for insert as begin insert into test3 values('sunny') end insert into test2 values('suresh')