Along with what was described in Solutions 1 & 2, you also have some other syntax errors:
This is what it should look like
CREATE PROCEDURE empinsert
@email varchar(50),
@Name varchar(50),
@FatherName varchar(50),
@Login varchar(50),
@Password varchar(50),
@Department Varchar(50),
@Designation varchar(50),
@weightage int
As
Begin
insert into emp_registration values(@email,@Name,@FatherName,@Login,@Password,@Department,@Designation)
END
if @Designation ='Manager'
SET @weightage = 7
else if @Designation = 'Asst.Manager'
SET @weightage = 5
else if @Designation= 'Deputy Manager'
SET @weightage = 6
else if @Designation = 'Team Leader'
SET @weightage = 4
else if @Designation = 'Executives'
SET @weightage= 3
else if @Designation = 'Clerk'
SET @weightage = 3
else if @Designation= "Officeassistant"
SET @weightage = 2
BEGIN
insert into Users values(@Login,@Password,@weightage)
End
Go