用T-SQL语句实现存储过程：任何连续整数的积

用T-SQL语句实现存储过程：任何连续整数的积

if Exists(Select name From sysobjects Where name='p_test' And type='P')
Drop Procedure p_test
Go
create proc p_test
@start_num int,
@end_num int
as
declare @cyc int
declare @size int
declare @count int
begin
set @cyc=1
set @size=(@end_num-@start_num)
set @count=@start_num
while @cyc<=@size
begin
set @start_num=@start_num+1
set @count=@count*@start_num
set @cyc=@cyc+1
end
select @count
END
go
EXEC p_test 1,5

写了这么多，分少就算了 不给就过分了哦

如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！

点此我要举报以上问答信息