Function Checking Prime Number in SQL Server
Hello to everyone,
In this article, I will try to give information about the function that checks the prime number in SQL Server.
In SQL Server, in some cases, you may want to check if the number you have is a prime number.
You can easily do this using the function below.
--Creating the function CREATE FUNCTION fn_isPrime ( @number INT ) RETURNS VARCHAR(50) AS BEGIN DECLARE @result VARCHAR(50); DECLARE @i INT = 2; WHILE (@i < @number) BEGIN IF (@number % @i = 0) BEGIN SET @result = 'The number entered is not a prime number'; BREAK; END; ELSE BEGIN SET @result = 'The number entered is a prime number'; END; SET @i += 1; END; RETURN @result; END; --Use of the function SELECT dbo.fn_isPrime(39);
When you create the function and run the above code, you will see the following result.
As can be seen, it has been checked whether the number is a prime number or not.
Good luck to everyone in business and life.