Famous If Else In Sql Server Ideas. Web else statement in sql server in ms sql, if…else is a type of conditional statement. Web from sql server 2012 you can use the iif function for this.

Select iif (obsolete ='n' or instock ='y', 1, 0) as salable, * from product. Ad flexible unterstützung für sql server und windows server administration. X > y — true.