2

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?

Thanks

Dragan

0

0

Browse other questions tagged or ask your own question.