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?

score 0 · Accepted Answer · edited May 23 '17 at 11:48

0

edited May 23 '17 at 11:48

Community

answered Sep 03 '09 at 21:04

Brisbe

Thanks, SELECT SERVERPROPERTY ('edition') returns "SQL Data Services" in SQL Azure CTP August 2009 – Mark Redman Sep 03 '09 at 21:31

1 Answers1