首页 > 代码库 > 2014-12-01 存储过程
2014-12-01 存储过程
---存储过程
alter proc ChaXun
as
begin
select *from Score
end
go
--执行
exec chaxun
--删除
drop proc chaxun
--输入参数的存储过程
alter proc jiayibai
@shuru int,
@canshu int
as
begin
print @shuru+@canshu
end
go
exec jiayibai 10,120
--是否闰年
create proc isRunNian
@year int
as
begin
if @year%4=0 and @year%100!=0
begin
print ‘是闰年‘
end
else if @year%100=0 and @year%400=0
begin
print ‘是闰年‘
end
else
begin
print ‘不是闰年‘
end
end
go
declare @jieguo int
exec @jieguo=isRunNian 2100
print @jieguo
----一元二次方程存储过程
alter proc yiyuanerci
@a int,
@b int,
@c int
as
begin
if @a=0
begin
--print ‘不是一元二次方程‘
return 1
end
else
begin
declare @sqrt decimal(18,2)
set @sqrt = @b*@b-4*@a*@c
if @sqrt>0
begin
--print ‘两个不同的根‘
return 2
end
else if @sqrt=0
begin
--print ‘两个相同的根‘
return 3
end
else
begin
--print ‘无解‘
return 4
end
end
end
go
declare @fanhui int
exec @fanhui = yiyuanerci 0,4,3
if @fanhui=1
print ‘请仔细阅读一元二次方程的构造规则‘
--out输出参数
alter proc outzhi
@shuru int,
@jiashi int output,
@jiaershi int output
as
begin
set @jiashi=@shuru+10
set @jiaershi=@shuru+20
return 1
end
go
declare @shuchu1 int,@shuchu2 int,@return int
exec @return=outzhi 15,@shuchu1 output,@shuchu2 output
print @shuchu1
print @shuchu2
print @return
2014-12-01 存储过程