Question

sql语句编程，用loop和while，分别输出1到100内素数和

Answer 1

--- 创建判断是否为素数函数
create function ChkIntIsSuShu(@No int)
returns tinyint
as
begin
if @No <=1
return 0
declare @maxV int, @Index int
set @maxV = @No -1
set @Index = 2
while @Index < @maxV
begin
declare @maxV2 int,@Index2 int
set @maxV2 = @maxV
set @Index2 = @Index
while @Index2 < @maxV2
begin
if @Index2 * @Index = @No
return 0
set @Index2 = @Index2 + 1
end
set @Index = @Index + 1
end
return 1
end
select dbo.ChkIntIsSuShu(13) -- 返回值1，表示素数，0表示非素数。
--- while 实例
declare @i int = 1,
@result int = 0
while @i <= 100
begin
if dbo.ChkIntIsSuShu(@i) =1
begin
set @result=@result + @i
end
set @i += 1
end
print @result

--补充 SQL 不支持LOOP 语法