IF...ELSE ใน T-SQL

มาดูตัวอย่าง ง่ายๆ ในการใช้ IF…ELSE ใน T-SQL กันครับ

USE pubs
  
IF (SELECT AVG(price) FROM titles WHERE type = 'mod_cook') < $15
BEGIN
    PRINT 'The following titles are excellent mod_cook books:'
    PRINT ' '
    SELECT SUBSTRING(title, 1, 35) AS Title
    FROM titles
    WHERE type = 'mod_cook'
END
ELSE
    IF (SELECT AVG(price) FROM titles WHERE type = 'mod_cook') > $15
BEGIN
    PRINT 'The following titles are expensive mod_cook books:'
    PRINT ' '
    SELECT SUBSTRING(title, 1, 35) AS Title
    FROM titles
    WHERE type = 'mod_cook'
END

About these ads