摘要:
ALTER PROCEDURE [dbo].[ST_GetCalendar_S] @Year INT, @Month INT ASBEGINDECLARE @Inmonth as varchar(7)SET @Inmonth = CONVERT(VARCHAR,@Year)+'-'+ CONVERT(VARCHAR,@Month)DECLARE @a table(id int identity(0,1),date datetime)INSERT INTO @a(date) SELECT TOP 31 @Inmonth + '-01' FROM sysobject 阅读全文