SQL Server Dates or Calendar Table for PowerPivot
- WBOYOriginal
- 2016-06-07 17:43:37782browse
SQL Server 2012 spCreateCalendarTable( , ) TRY tblCalendar 14 END TRY CATCH 17 END CATCH tblCalendar( , , 23 MonthNumber int , ( 10 ), 25 MonthNameSorted varchar ( 20 ), 26 DayNumber int , ( 10 ), ( 2 ) 29 ) tblCalendar ( , , 43 MonthNumbe
SQL Server 2012
spCreateCalendarTable( , ) TRY tblCalendar 14 END TRY CATCH 17 END CATCH tblCalendar( , , 23 MonthNumber int, (10), 25 MonthNameSorted varchar(20), 26 DayNumber int, (10), (2) 29 ) tblCalendar ( , , 43 MonthNumber, , 45 MonthNameSorted, 46 DayNumber, , ) VALUES ( 50 @curdate, 51 Year(@curdate), 52 Month(@curdate), 53 DateName(m,@curdate), (((m,@curdate), (@curdate), 64 DateName(weekday,@curdate), () AS char(1)) 68 ) (day,1,@curdate) spCreateCalendarTable , tblCalendar ，香港服务器，网站空间，香港服务器