개발자의 사투

CONVERT(CHAR(10), DATETIME, 23) 2021-01-02 YYYY-MM-DD CONVERT(CHAR(23), DATETIME, 21) 2021-01-02 13:14:15.678 YYYY-MM-DD HH:MM:SS.MS CONVERT(CHAR(8), DATETIME, 112) 20210102 YYYYMMDD

DECLARE @TEMP TABLE ( idx INT, value varchar(10) ) INSERT INTO @TEMP(idx, value) values (1, 'Ga') INSERT INTO @TEMP(idx, value) values (2, 'Na') INSERT INTO @TEMP(idx, value) values (2, 'Da') INSERT INTO @TEMP(idx, value) values (3, 'Ra') INSERT INTO @TEMP(idx, value) values (3, 'Ma') INSERT INTO @TEMP(idx, value) values (3, 'Ba') SELECT * FROM @TEMP WHERE 1=1 SELECT DISTINCT STUFF(( SELECT ',' ..