Post reply

Interesting: I would like to know your views about.

  • December 6, 2006 at 12:48 am

    #175556

    What is the output of query below?

    SELECT

    @@microsoftversion / 0x01000000

  • 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]

  • 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

  • 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]

  • 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.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply