用户需要传入年份,获取该年份2月份的天数。可以写成一个用户自定义函数。
![](https://i-blog.csdnimg.cn/blog_migrate/8f900a89c6347c561fdf2122f13be562.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/961ddebeb323a10fe0623af514929fc1.gif)
CREATE
FUNCTION
[
dbo
]
.
[
DaysOfFebruary
]
(
@Year INT
)
RETURNS INT
AS
BEGIN
RETURN CASE WHEN ( @Year % 4 = 0 AND @Year % 100 <> 0 ) OR ( @Year % 400 = 0 ) THEN 29 ELSE 28 END
END
(
@Year INT
)
RETURNS INT
AS
BEGIN
RETURN CASE WHEN ( @Year % 4 = 0 AND @Year % 100 <> 0 ) OR ( @Year % 400 = 0 ) THEN 29 ELSE 28 END
END
代码演示:
SELECT
[
dbo
]
.
[
DaysOfFebruary
]
(
2011
)
执行结果: