闲的没事,弄了一个sql打印日历,做个记录。
SET NOCOUNT ON
SET DATEFIRST 1
DECLARE @sDate DATE,@eDate DATE,@Year INT,@Month INT,@Weeks INT,
@tmpDate DATE,@Week INT,@Weekday NVARCHAR(3)
SELECT @sDate=DATEADD(year,-3,GETDATE()),@eDate=GETDATE()
IF object_id('tempdb..#tmpDate')IS NOT NULL
DROP TABLE #tmpDate
CREATE TABLE #tmpDate(
[Date] DATE,
[Year] INT,
[Month] INT,
[Week] INT,
[Weekday] NVARCHAR(3),
Weeks INT,
WeeksOrderBy VARCHAR(10)
)
WHILE(@sDate<=@eDate)
BEGIN
IF(@Month!=month(@sDate))
BEGIN
SET @tmpDate=@sDate
INSERT INTO #tmpDate(Year,Month,Weeks,[Week],[Weekday],WeeksOrderBy)
VALUES(@year,@Month,@Weeks,@Week,@Weekday,CONVERT(VARCHAR(3),@Weeks)+'cr')
end
SELECT @year=year(@sDate),@Month=month(@sDate),@Weeks=DATENAME(w