Scope Identity:-

It should be auto generated column and primary key.It will be get last inserted primary key Id.

Ex:-

insert into User3 values('gfgf')

select SCOPE_IDENTITY()