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. ... <看更多>

I've seen this where clause in many examples on internet but not the reason why it is required. sql-server · Share. ... <看更多>