判断整数是否为质数 create function checkprimenumber(@no bigint) returns tinyint as begin if @no <= 1 return 0 declare @maxv bigint, @index bigint set @maxv = @no - 1 set @index = 2 while @index < @maxv begin declare @maxv2 bigint, @index2 bigint 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 goselect dbo.checkprimenumber(13) -- 返回值1，表示素数，0表示非素数。