DECLARE @regdate varchar(10);
SET @regdate = ‘2024-04-24’;
SELECT * FROM study_group_tbl WHERE LEFT(group_no, 6) = ‘202400’ AND del_yn = ‘N’ AND regdate = @regdate
[MSSQL] SSMS 쿼리작성시 변수 사용
0 Comments
DECLARE @regdate varchar(10);
SET @regdate = ‘2024-04-24’;
SELECT * FROM study_group_tbl WHERE LEFT(group_no, 6) = ‘202400’ AND del_yn = ‘N’ AND regdate = @regdate