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

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