CREATE proc sp_person_sel_by_name @name varchar(50) AS SELECT * FROM emp WHERE name like '%'+ @name +'%' GO