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