22,207
社区成员
发帖
与我相关
我的任务
分享
create procedure StuInfo
@sno varchar(8)
as
select sno,sname,sex,birthday,phone
from student
where student.sno like @sno+'%'
go
exec StuInfo '08'
create procedure StuInfo
@sno varchar(8)
as
select sno,sname,sex,birthday,phone
from student
where sno=@sno and sno like '08%'