SQL Server Performance

@@version year

Discussion in 'SQL Server 2008 General Developer Questions' started by i.netdeveloper, Jul 15, 2010.

  1. i.netdeveloper Member

    Hi, I want to a script based on sql server version year, because some objects are not supported in 2000. We have two enviorments.
    something like
    if @@version = 'Microsoft Sqlserver 2000'
    --do this
    if @@version ='Microsoft Sqlserver 2008'
    -- do this
    I really appreciate your help.
    Thanks...
    i.netdeveloper, Jul 15, 2010
    #2

  2. Adriaan New Member

    Adriaan, Jul 16, 2010
    #3

  3. satya Moderator

    This is locked.
    satya, Jul 16, 2010
    #4

Share This Page