Update auto_increment in SQL Server

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()