存储过程

create proc p1
as
begin
select * from sc where sno = ‘2020005’

end
exec p1
—begin end 相当于（） 存储过程相当于数据库的函数

select *from

create proc p2 @sno varchar(13),@cno varchar(13)
as
begin
select sc.*,cou.ccredit from sc,cou where sno = @sno and sc.cno = @cno and sc.cno = cou.cno
select grade,
end

exec p2 ‘2020004’,‘20203’

select *from sc