목록Where (1)

DJ메탈짱™의 Free Style

[MS-SQL] Where, Datetime 컬럼, 인덱스, Convert, Cast, String 변환

DECLARE @vFrom VARCHAR(19) DECLARE @vTo VARCHAR(19) DECLARE @TODAY DATETIME SET @TODAY = GETDATE() SET @vFrom = CONVERT(CHAR(11),@TODAY,120) + '00:00:00.000' SET @vTo = CONVERT(CHAR(11),@TODAY,120) + '23:59:59.997' SELECT TOP 10 SEARCH_ID, -- 일련번호 EMPLOYEE_NUMBER, -- 사원번호 SEARCH_VALUE, -- 검색어 CONVERT(CHAR(19),INSERT_DATE,120) AS INSERT_DATE FROM TB_CMM_COMMON_SEARCH WHERE INSERT_DATE >= @vFrom A..
일(job)/DBMS 2016. 1. 14. 16:08
이전 Prev 1 Next 다음