判断数字是否为奇数或偶数，判断数字奇数偶数
判断数字是否为奇数或偶数，可以参考下面2个自定义函数：
奇数：
![]()
SET ANSI_NULLS
ON
GO
SET QUOTED_IDENTIFIER
ON
GO
-- =============================================
-- Author: Insus.NET
-- Blog: https://insus.cnblogs.com
-- Create date: 2019-06-02
-- Update date: 2019-06-02
-- Description: 是否为奇数
-- =============================================
CREATE FUNCTION [dbo].
[svf_IsOdd]
(
@number INT
)
RETURNS BIT
AS
BEGIN
RETURN CASE WHEN @number % 2 <> 0 THEN 1 ELSE 0 END
END
GO
Source Code
偶数：
![]()
SET ANSI_NULLS
ON
GO
SET QUOTED_IDENTIFIER
ON
GO
-- =============================================
-- Author: Insus.NET
-- Blog: https://insus.cnblogs.com
-- Create date: 2019-06-02
-- Update date: 2019-06-02
-- Description: 是否为偶数
-- =============================================
CREATE FUNCTION [dbo].
[svf_IsEven]
(
@number INT
)
RETURNS BIT
AS
BEGIN
RETURN CASE WHEN @number % 2 = 0 THEN 1 ELSE 0 END
END
GO
Source Code
举例说明：
![]()
;
WITH Digits
AS
(
SELECT 0 AS digit
UNION ALL
SELECT digit
+ 1 FROM Digits
where digit
< 9
)
SELECT [digit],
[dbo].
[svf_IsEven](
[digit])
AS [even],
[dbo].
[svf_IsOdd](
[digit])
AS [odd] FROM Digits
Source Code
运行结果：
http://www.htsjk.com/Sql_Server/25602.html
www.htsjk.Com
true
http://www.htsjk.com/Sql_Server/25602.html
NewsArticle
判断数字是否为奇数或偶数，判断数字奇数偶数 判断数字是否为奇数或偶数，可以参考下面2个自定义函数： 奇数： SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ==================================...
本站文章为和通数据库网友分享或者投稿，欢迎任何形式的转载，但请务必注明出处.
同时文章内容如有侵犯了您的权益，请联系QQ：970679559，我们会在尽快处理。