if (ex**ts (select * from sys.objects where name = 'proc_stu')) drop proc proc_stugocreate proc proc_stu(@sname varchar(8) ='张%')asselect student.sno,sname,lname,gradefrom student left join sc on student.sno=sc.sno left join lesson on sc.lno=lesson.lnowhere sname like @snamego 20210311