Update auto_increment in SQL Server
Create PROC SP_UpdateEmployee
@Id int = null out,
@employeename varchar(50),
@Active bit
AS
INSERT INTO Employeemaster(employeename,Active)values(@employeename,@Active)
Set @Id = Scope_Identity()