How to check the conditions in storedprocedure

Question

How to check the conditions in

storedprocedure

 

i need to check the empid

 

if empid exits then print message like exits 

 

if not then save  into db

 

if empid null then print msg 

 

after i need to check the year  is madatoryfield

 

if year  exits print msg 

 

same like above 

 

please help me this 

Thanks