将存储过程stu_pr改为查询学号为20012211的学生的资料。
alter procedure stu_pr
@sno varchar (10)
as
select distinct * from student
where sno='20012211'
执行:
exec stu_pr @sno=’20012211’
将存储过程stu_pr改为查询学号为20012211的学生的资料。
alter procedure stu_pr
@sno varchar (10)
as
select distinct * from student
where sno='20012211'
执行:
exec stu_pr @sno=’20012211’