how to insert the data into table in storedprocedure

Question

i need to insert the data into the table 

 

if empid exists 

 

how?

 below u can find the code  

 

if(select Count([Num]) from [Employee] where [Num]=@empId)<=0

set @records='empid doesnot exist'

 

please help me this

 

thanks