[email protected]
如果是单数的话返回值为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 @[email protected]%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