The CASE statement is the closest to IF in SQL and is supported on all versions of SQL Server. SELECT CAST( CASE WHEN Obsolete = 'N' or InStock = 'Y' THEN 1 ... ... <看更多>

in this tutorial, i will show you how to use conditional statement in SELECT query. ... <看更多>

This is standard SQL behaviour: A CASE expression evaluates to the first true condition. If there is no true condition, it evaluates to the ELSE part. If ... ... <看更多>