I am politely disagreeing with statement that 'SQL 2008 is the standard'.

Shouldn't it be the standard(s) we have (note I am using "we"), are those of what our members are using?

I also understand it may not be optimal to have to two SQL versions in your computers, even if one is running in a virtual machine. It will only be by force or migration work to have two versions.

I also understand the difficulty of people making QoDs. In my workplace, I too have difficult people.

Just to add something useful, I hope, I am humbly posting a workaround:

if right(left((SELECT @@VERSION), 25), 4) = '2008'

select '2008'

--insert into a (b) values (1), (2), (3)

if right(left((SELECT @@VERSION), 25), 4) = '2005'

begin

select '2005'

--insert into a (b) values (1)

--insert into a (b) values (2)

--insert into a (b) values (3

end

else

select '6.5?'

I do believe a lot of you can make it better.