13 December 2013

Get identity value after insert in SQL Server

declare @newId int
insert into tbl_employee(Name,Sal,address)values('adi','11111','bangalore')
select @newId = Scope_Identity()
    -- return @newID
     --(or)
     print @newID

No comments:

Post a Comment