Passing value to one table and updating in parent table
===

I have two tables. 
dbo.Emp
EmpID(PK) | Name | TypeID(FK) 

dbo.EmpType
TypeID(PK) | Type

TypeID: AutoIncrement only in dbo.EmpType

When I update value for TypeID in Emptype, it needs get stored in TypeID of dbo.Emp
I used SP which is not working. 

    Create Procedure bridge_Type(
    @EmpID INT,
    @Name	varchar(50),
    @Mob2	numeric(10,0),
	@Email	varchar(50),
	@Type	varchar(50)
    )
    AS 
    DECLARE @TYPEID int
    Set NOCOUNT OFF

    BEGIN TRANSACTION
    Insert into dbo.Emp VALUES (@EmpID, @Name, @Mob2, @Email, @TYPEID)
    IF @@ERROR <> 0
    BEGIN 
    ROLLBACK
    RETURN
    END

    INSERT INTO dbo.EmpType VALUES (@Type)
    IF @@ERROR <> 0 
    BEGIN     
    ROLLBACK     
    RETURN 
    END  

    declare @id int
    SET @id= @TYPEID;
    Update Dbo.Emp 
    Set @TYPEID= (Select TypeID from dbo.EmpType
			  WHERE	 TypeID=@typeID)
    COMMIT 