How can I detect which version of SQL (eg SQL 2008 or SQL Azure)

Question

I need to detect which version of SQL I am dealing with to perorm various tasks, I need specifically detect if I am on SQL 2008 or SQL Azure.

How can I do this with detection code written in SQL?

Answer 1

A good place to start might be: http://stackoverflow.com/questions/602677/programmatically-detect-sql-server-edition.