Check if SQL Server version is 2005 or lower

This script shows a simple way to check if the current version of SQL Server is 2005 or lower.It exploits the new server property called 'BuildClrVersion' which is not defined on SQL Server 2000 (and lower) but has just been introduced with 2005.It may be useful to condition the execution of a piece of code […]

2007-08-16 (first published: )

222 reads

Blogs

Your First Jupyter Notebook

By

In April, I said I was going to start learning Jupyter Notebooks. It’s November....

Using Visual Studio Code

By

I’m a creature of habit. I have my routine when I get to my...

Docker Containers and Persistent Data

By

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get...

Read the latest Blogs

Forums

Numeric and Decimal

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Numeric and Decimal, which is...

Turn If statement into Case

By GrassHopper

How can I convert this into a Case statement so that the query is...

The Conference Springboard

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Conference Springboard

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Missing Data

See possible answers