Interesting: I would like to know your views about.

• Bhudev Prakash

  SSC-Addicted

  Points: 471

  More actions

  December 6, 2006 at 12:48 am

  #175556

  What is the output of query below?

  SELECT

  @@microsoftversion / 0x01000000

• Luke L

  SSC-Dedicated

  Points: 35547

  More actions

  December 6, 2006 at 7:14 am

  #676202

  It's basically the same as this...

  convert(int,substring(convert(binary(4), @@microsoftversion),1,1))

  @@MicrosoftVersion give what versoin of the engine you are using.  for me its 8 because I use 2000. for 2005 it's 9.  Not sure about previous versoin because I don't have the ability to test them. 

  To help us help you read this[/url]For better help with performance problems please read this[/url]

• SQLBill

  SSC Guru

  Points: 51440

  More actions

  December 6, 2006 at 8:47 am

  #676257

  Previous versions were 6 & 7. Microsoft numbers the versions one up. That shows the progression even when the name doesn't.

  -SQLBill

• Luke L

  SSC-Dedicated

  Points: 35547

  More actions

  December 6, 2006 at 8:58 am

  #676264

  SQBill, I figured as much, I just wasn't certain about how they represented 6.5 etc...

  Thanks.

  To help us help you read this[/url]For better help with performance problems please read this[/url]

• Bhudev Prakash

  SSC-Addicted

  Points: 471

  More actions

  December 7, 2006 at 6:08 am

  #676558

  Thanks Luke L & SQBill -

  I picked this from SQL Profiler when Opening SQL Server Management Studio. I knew that it gives 9 with SQL 2005 and 8 with SQL 2000 but not appropriate answer in well manner or there were not help.