create proc p_姓名 asselect * from 学生表where 姓名="你指定的学生姓名"
Create Procedure SearchByName( @Name Varchar(20))AsBeginSelect * From Students Where Name = @NameEnd
找百度百科去