With the help of below sql script we will find the number is
prime number or not.
DECLARE @Number AS INT = 7
SELECT
CASE WHEN COUNT(DISTINCT num1.number) > 0
THEN
cast(@Number as varchar(10))+ ' is Not a Prime Number'
ELSE
cast(@Number as varchar(10)) + ' is Prime Number'
END [Check Prime]
FROM MASTER..SPT_VALUES AS num1
WHERE num1.Number > 1
AND num1.Number < @Number
AND @Number % num1.Number = 0
|
See the output
See with another example
