Is there a ternary conditional statement in T-SQL?

Question

What are the alternatives for implementing the following query:

select * from table where isExternal = @type = 2 ? 1 : 0 

Answer 1

Use case :

 select * from table where isExternal = case @type when 2 then 1 else 0 end 

Answer 2

In SQL Server 2012, you can use the IIF function:

 SELECT * FROM table WHERE isExternal = IIF(@type = 2, 1, 0) 

Also note: in T-SQL, the assignment (and comparison) operator is simply = (and not == - this is C #)