use TestDB
go
if object_ID('GetStrdent','P') is not null--如果存在这个存储过程,则删除
Drop Procedure GetStrdent
go
create procedure GetStudent--创建存储过程
@SNO int,--参数
@SName varchar(20)--参数
AS
select SNO,SName from strdent
where SNO like @SNO and SName like @SName
go