How to use IF ELSE in an SQL Select query
In MSSQL IF ELSE is not supported inside the SQL-Query. For a similiar behaviour you should use CASE WHEN keyword. Sample Query
How to write a case-sensitive MS-SQL query
When using a case-insensitive Server Collation your sql queries are case-insensitive by default. To write a case-sensitive MS-SQL query, you need to add the keyword. In this sample we used…