DECLARE @search_sno varchar(30) gocreate proc search_name1 (@search_sno varchar(30)) asselect stu_name,stu_dept from studentwhere stu_sno=@search_sno goEXEC search_name1 @search_sno = '2'go执行通过!