Prime No Script in T-SQL

Here this script is check weather no from 1 to 100 is Prime or not if no is Prime than print it.

SET NOCOUNT on
go
declare @val bigint
declare @tval bigint
declare @oval bigint
declare @rem bigint
declare @res bigint
declare @divby int
declare @fg bit


set @res = 0
set @val = 7
set @tval = @val
set @divby = 2
set @fg = 'true'
--

declare @inputTable table(_val int)
declare @i int
set @i = 1

while(@i<=100) begin insert into @inputTable values(@i) set @i = @i + 1 end declare ibuffer cursor fast_forward for select _val from @inputTable open ibuffer fetch next from ibuffer into @val while (@@fetch_status != -1) BEGIN set @divby = 2 set @fg = 'true' set @tval = @val set @oval = @val set @res = 0 while(@divby > 1 and @divby <= @val -1) begin set @rem = @tval % @divby if(@rem = 0) begin set @fg = 'false' break end set @divby = @divby + 1 end if(@fg = 'true') begin print 'Given no is prime --- > ' + cast(@oval as varchar)
end


fetch next from ibuffer into @val
End
deallocate ibuffer

Output will be...
Given no is prime --- > 1
Given no is prime --- > 2
Given no is prime --- > 3
Given no is prime --- > 5
Given no is prime --- > 7
Given no is prime --- > 11
Given no is prime --- > 13
Given no is prime --- > 17
Given no is prime --- > 19
Given no is prime --- > 23
Given no is prime --- > 29
Given no is prime --- > 31
Given no is prime --- > 37
Given no is prime --- > 41
Given no is prime --- > 43
Given no is prime --- > 47
Given no is prime --- > 53
Given no is prime --- > 59
Given no is prime --- > 61
Given no is prime --- > 67
Given no is prime --- > 71
Given no is prime --- > 73
Given no is prime --- > 79
Given no is prime --- > 83
Given no is prime --- > 89
Given no is prime --- > 97