存储过程

use StudentDB

--（1）检索学号的全体学生的学号，姓名和性别；
select Id,sname,sex from Students where sno='20110101'
 
 go
--（2）创建存储过程检索为用户输入的学习课程号的学生学号与姓名；
if exists(select 1 from sysobjects where name='proc_test')

begin

drop proc proc_test

end

go

create procedure proc_test

@courseid int

as

select('@courseid')

select Id,sname from Students

go

create procedure proc_test2

@courseid int

as

begin

  select('@courseid')

  select Id,sname from Students

end

go

----------定义一个简单的存储过程

create   procedure   sp_getOrders

 @orderID int = null

as

 if(@orderID is null)

   begin

      print 'null'

   end

   else

     begin

    print 'correct'

    end

    select * from Students where ID=@orderID

 GO

--------执行存储过程

 declare @i int, @j int , @k int

 set @i = 1;

 set @j = 2;

 select @k = @i + @j

 ----exec sp_getOrders 10248

 select @i;

 GO