MS-SQL/Query45 간단한 달력 만들어보기 예제 IF EXISTS(SELECT * FROM DBO.SYSOBJECTS WHERE XTYPE = 'U' AND NAME = 'T_CARLENDAR') BEGIN DROP TABLE T_CARLENDAR END CREATE TABLE DBO.T_CARLENDAR ( TYEAR NVARCHAR(4), TMONTH NVARCHAR(2), TDAY NVARCHAR(2), TDW NVARCHAR(30), HOLIDAYBOOL BIT DEFAULT 0, HOLIDAYINFO NVARCHAR(100), MEMO TEXT ) DECLARE @LASTDATETIME DATETIME SET @LASTDATETIME = '2015-12-31' DECLARE @DATETIME DATETIME SET @DATETIME = '20.. 2013. 2. 1. 이전 1 ··· 9 10 11 12 다음