동적 쿼리 예제

동적 쿼리 예제

DECLARE @sql VARCHAR(MAX)
 
SET @sql = "SELECT * FROM dbo.InsaMst where";
 
IF @Gubun = 'Y'
       sql += ToiDate != '____/__/__' and ToiDate <= @ToiDate
 
IF @Gubun = 'N'
       sql += (ToiDate >= @ToiDate or ToiDate = '____/__/__')
 
ELSE 
       sql += ToiDate = ToiDate 
 
exec(@sql)