목록mssql query (1)

기억의 습작

MS-SQL 기본쿼리

LIKE select COUNT(*) from T_FILE where REG_DT LIKE '[0-1][0-9] [0-9 ][0-9] 2019%'; select COUNT(*) from T_FILE where REG_DT LIKE '01 [0-9 ][0-9] 2019%'; // 1월 select COUNT(*) from T_FILE where REG_DT LIKE '02 [0-9 ][0-9] 2019%'; // 2월 BETWEEN select COUNT(*) from T_FILE where REG_DT BETWEEN CONVERT(datetime,'2011-01-01 00:00:00:000') AND CONVERT(datetime,'2011-12-31 23:59:59:999'); Create View T..
DB/mssql 2021. 8. 29. 01:21
이전 Prev 1 Next 다음