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
，香港服务器，网站空间，香港服务器
京公网安备 11010802041100号 | 京ICP备19059560号-4 | PHP1.CN 第一PHP社区 版权所有 