/*-------------------------------------------------- description:取得Studen資料 author:Kyle date:2018/5/31 testing Code: -------------------------------------------------- exec MyStudent_GetList @Student_Name='KYLE' -------------------------------------------------- drop Procedure MyStudent_GetList --------------------------------------------------*/ Create Procedure [dbo].[MyStudent_GetList] @Student_Name nvarchar(100) =null AS BEGIN Select * from MyStuden Where Student_Name=@Student_Name END