even and odd number in sql server 2008 with code

how to check number is even or odd in sql server using procedure.
it is very simple  to find out even or odd number .just create procedure and write
given functionality or logic in sql server 2008



ALTER procedure [dbo].[even_odd]
(@@val int)
as
begin
if (@@val%2=0)
begin
print 'even number'
end
else
print 'odd number'

end

Share This