I would like to create computed index on a table if sql server is 2008 or newer and a simple index if sql server is 2005 or older:
-- check for sql server version if (select cast(left(cast(serverproperty('productversion') as varchar), 4) as decimal(5, 3))) >= 10 CREATE unique nonclustered index ix1_table ON table (column1, column2) WHERE column1 is not null and column2 is not null ELSE CREATE nonclustered index ix1_table ON table (column1, column2)
problem is that the whole statement is evaluated and on sql server 2005 this throws an error
Incorrect syntax near the keyword 'WHERE'.
Is it possible to somehow create different index based on sql server version?