1234567 SELECT *FROM INSAMSTwhere (@gubun = 'Y' AND (ToiDate != '____/__/__' and ToiDate = @ToiDate OR ToiDate = '____/__/__')) Colored by Color Scriptercs 1234567891011121314and ( (@GuBun = 'Y' AND (Insa.ToiDate >= @ToiDate or Insa.ToiDate = '____/__/__')) or (@GuBun = 'N' and Insa.ToiDate != '____/__/__' and Insa.ToiDate
동적 쿼리 예제 12345678910111213141516DECLARE @sql VARCHAR(MAX) SET @sql = "SELECT * FROM dbo.InsaMst where"; IF @Gubun = 'Y' sql += ToiDate != '____/__/__' and ToiDate = @ToiDate or ToiDate = '____/__/__') ELSE sql += ToiDate = ToiDate exec(@sql) Colored by Color Scriptercs
where 절에서 and 연산 사이에 같은값 or로 묶을려면 그냥 ( ) 괄호로 묶어줘야 예외가 생기지 않는다!1(Insa.ToiDate >= @ToiDate or Insa.ToiDate = '____/__/__')cs
123-- ISNULL ( "null check 값" , "null이면 보여줄 값" ) ISNULL(max(InsaCode)+1,CONVERT(CHAR(4),CURRENT_TIMESTAMP,12) + @CompCode + '001') Colored by Color Scriptercs
