菜鸟求一个单数双数的函数
变量@str
如果是单数的话返回值为1
如果是双数的话返回值为0
@str%2
[解决办法]
create function fnTest(@str int)
returns int
as
begin
return case when @str%2 = 0 then 0 else 1 end
end
GO
[解决办法]
declare @str int
set @str=24
if @str%2 =0
print 0
else
print 1
[解决办法]
CREATE FUNCTION [dbo].[NumCheck] ( @id int)
RETURNS int AS
BEGIN
declare @F int
select @F=@id%2
return @F
END
[解决办法]
CREATE FUNCTION [dbo].[NumCheck] ( @id int)
RETURNS int AS
BEGIN
declare @F int
select @F=abs(@id%2)
return @F
END
select dbo.NumCheck(2)
--0
select dbo.NumCheck(-113257)
--1
