Skip to content

Instantly share code, notes, and snippets.

@FilipDeVos

FilipDeVos/@@microsoftversion_query.sql

Created May 12, 2011 14:58
Show Gist options
  • Save FilipDeVos/968671 to your computer and use it in GitHub Desktop.
Save FilipDeVos/968671 to your computer and use it in GitHub Desktop.
Download ZIP
Determine SQL Version 5
Raw
@@microsoftversion_query.sql
SELECT CASE @@microsoftversion/ 0x01000000
WHEN 8 THEN 'sql 2000'
WHEN 9 THEN 'sql 2005'
WHEN 10 THEN 'sql 2008'
WHEN 11 THEN 'sql Denali'
END
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment