参数化like模糊查询存储过程

create proc GetDataByName

@name

as

select sno,cname,sname,score

from (student left join sc on student.sno=sc.sno)

left join sxx on student.partno=sxx.partno

where sxx.deparementname=student.sname

where student.sname like @name+'%'