Open Minded (4/22/2010)
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.
haha... it was a nice one at 6.5? ha ha:hehe::-D
- Swaroop R -