Post reply

SUBSTRING

  • August 5, 2010 at 1:04 pm

    #227508

    Hello Everyone

    I know the Subject Title is pretty sad.

    This is what I am trying to get from the string returned from @@VERSION

    Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (Intel X86) Mar 29 2009 10:27:29 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition on Windows NT 5.1 <X86> (Build 2600: Service Pack 3)

    I would like to have Only the number "2008" and nothing else.

    Any suggestion as to what I can do to get that with the String manipulation?

    Thanks in advance

    Andrew SQLDBA

  • August 5, 2010 at 1:30 pm

    #1203094

    Andrew , are u trying to find if your SQL Server Version is 2005 or 2008 ? or rather which version of SQL Server?

  • August 5, 2010 at 1:38 pm

    #1203106

    You may use something like this

    select right(left('Microsoft SQL Server 2008',28),4)

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • August 5, 2010 at 2:00 pm

    #1203117

    SELECT SUBSTRING(@@VERSION, PATINDEX('%[0-9][0-9][0-9][0-9]%', @@VERSION), 4)

    Scott Pletcher, SQL Server MVP 2008-2010

  • August 5, 2010 at 2:14 pm

    #1203127

    Scott

    Thank you very much, this is exactly what I was looking for.

    Andrew SQLDBA

  • August 5, 2010 at 4:15 pm

    #1203163

    scott.pletcher (8/5/2010)

    SELECT SUBSTRING(@@VERSION, PATINDEX('%[0-9][0-9][0-9][0-9]%', @@VERSION), 4)

    That's great!!! - really!

    Can you explain little bit, how you find the idea, to use PATINDEX like this in your very nice & simple script !?! :w00t:

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • August 5, 2010 at 4:19 pm

    #1203164

    Yes, I think it is really Great. I would have never thought to use it, that is why I asked on here.

    Very nice script

    Thank You again

    Andrew SQLDBA

  • August 5, 2010 at 4:23 pm

    #1203165

    Lol. Not sure, just an idea that pops into your head.

    When you look at the output of version, you see that the first four consecutive digits in the result are always the SQL year, so that pattern just picks up the first four consecutive digits 🙂 .

    Scott Pletcher, SQL Server MVP 2008-2010

  • August 5, 2010 at 4:24 pm

    #1203166

    AndrewSQLDBA (8/5/2010)

    Yes, I think it is really Great. I would have never thought to use it, that is why I asked on here.

    Very nice script

    Thank You again

    Andrew SQLDBA

    This is the an MVP's way !!! - really cool!

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • August 5, 2010 at 4:27 pm

    #1203167

    scott.pletcher (8/5/2010)

    Lol. Not sure, just an idea that pops into your head.

    When you look at the output of version, you see that the first four consecutive digits in the result are always the SQL year, so that pattern just picks up the first four consecutive digits 🙂 .

    The very interesting part is : "Not sure, just an idea that pops into your head"

    Once again - it's cool, yea pops into your head!!! :w00t::w00t::w00t:

    Thank you! 😉

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

Viewing 10 posts - 1 through 9 (of 9 total)

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