This is an example of how to work with IF and ELSE in T-SQL. I hope it helps you out!
No download links available.