xp_msver function : xp_msver « System Settings « SQL Server / T-SQL Tutorial

1. SQL Server / T-SQL Tutorial
2. System Settings
3. xp_msver

4>    CREATE TABLE #VersionTable(
5>       [Index] int PRIMARY KEY,
6>       Name varchar(30),
7>       Internal_Value int,
8>       Character_Value varchar(250)
9>    )
10>    GO
1>
2>    INSERT INTO #VersionTable
3>    EXEC master..xp_msver
4>
5>    DECLARE @Version int
6>
7>    SELECT @Version = (SELECT Internal_Value
8>                                 FROM #VersionTable
9>                                 WHERE Name = 'ProductVersion')
10>    IF (@Version) >= 524288
11>       PRINT 'Running SS2K Beta 2 or Later'
12>    ELSE
13>       IF @Version >= 458752
14>          PRINT 'Running 7.0 RTM or Later'
15>       ELSE
16>          PRINT 'Running Pre 7.0 RTM Version'
17> GO

(20 rows affected)

(20 rows affected)
Running SS2K Beta 2 or Later
1>    DROP TABLE #VersionTable
2> GO