sql 存储过程篇

 1 /*
 2  无参存储过程
 3 */
 4 create procedure pro_GetStuInfo
 5 as
 6 begin
 7   select * from StuInfo
 8 end
 9 --调用
10 execute pro_getStuInfo
11 
12 /*
13  无输出参数的存储过程
14 */
15   create procedure pro_GetStuInfo11(@stuNo nvarchar(50))
16 as
17 begin
18   select * from StuInfo where stuNO=@stuNo
19 end
20 --调用
21 execute pro_GetStuInfo11 @stuNo= ‘2013‘
22 
23 /*
24  有输出参数的存储过程
25 */
26 alter procedure pro_GetStuInfo22(@stuNo nvarchar(50),@name nvarchar(50) output)
27 as
28 begin
29   select @name=name from StuInfo where stuNO=@stuNo
30 end
31 ---调用
32 declare @name1 nvarchar(50)
33 exec  pro_GetStuInfo22 ‘2013‘ ,@name1 output--注意格式问题
34 print @name1