创建月份列表存储过程-优快云博客

本文链接：https://blog.youkuaiyun.com/liyonghui__521/article/details/86706943

create FUNCTION [dbo].[F_getMonth]
(
@datetimeNow datetime--获取时间
)
RETURNS @SplitStringsTable TABLE --输出的数据表
(
[id] int identity(1,1),
[value] nvarchar(50)
)
AS
BEGIN
   INSERT INTO @SplitStringsTable([value]) VALUES((CONVERT(char(4), GETDATE(), 120)+'-01'));
   INSERT INTO @SplitStringsTable([value]) VALUES((CONVERT(char(4), GETDATE(), 120)+'-02'));
   INSERT INTO @SplitStringsTable([value]) VALUES((CONVERT(char(4), GETDATE(), 120)+'-03'));
   INSERT INTO @SplitStringsTable([value]) VALUES((CONVERT(char(4), GETDATE(), 120)+'-04'));
   INSERT INTO @SplitStringsTable([value]) VALUES((CONVERT(char(4), GETDATE(), 120)+'-05'));
   INSERT INTO @SplitStringsTable([value]) VALUES((CONVERT(char(4), GETDATE(), 120)+'-06'));
   INSERT INTO @SplitStringsTable([value]) VALUES((CONVERT(char(4), GETDATE(), 120)+'-07'));
   INSERT INTO @SplitStringsTable([value]) VALUES((CONVERT(char(4), GETDATE(), 120)+'-08'));
   INSERT INTO @SplitStringsTable([value]) VALUES((CONVERT(char(4), GETDATE(), 120)+'-09'));
   INSERT INTO @SplitStringsTable([value]) VALUES((CONVERT(char(4), GETDATE(), 120)+'-10'));
   INSERT INTO @SplitStringsTable([value]) VALUES((CONVERT(char(4), GETDATE(), 120)+'-11'));
   INSERT INTO @SplitStringsTable([value]) VALUES((CONVERT(char(4), GETDATE(), 120)+'-12'));
   RETURN;
END