查看SQLServer版本号和补丁号
有两种方法：第一步：使用SQL语句查询select@@version查询结果如下：MicrosoftSQLServer2000-8.00.2039(IntelX86)May3200523:18:38Copyright(c)1988-2003MicrosoftCorporationPersonalEditiononWindowsNT5.1(Build2600:ServicePack2)
其
实
在
C:\Program
Files\Microsoft
SQL
Server\MSSQL\Binn\sqlservr.exe点击鼠标右键查看版本也能得到，不过信息比较简单而已。8.00.2039就代表安装的SQLServer的版本了。对应以下的表格，可以查出来具体对应的补丁版本。8.00.2039表示安装了SP4，8.00.760表示安装了SP3。第二步：对照表格查找具体的补丁版本SQLServerVersions@VersionSQLServerVersionReleased
6.50.201SQLServer6.5RTM6.50.213SQLServer6.5withServicePack16.50.240SQLServer6.5withServicePack26.50.258SQLServer6.5withServicePack36.50.281SQLServer6.5withServicePack46.50.415SQLServer6.5withServicePack56.50.416SQLServer6.5withServicePack5a7.00.623SQLServer7.0/MSDE1.0RTM7.00.699SQLServer7.0SP1July19997.00.842SQLServer7.0SP2March20th,20007.00.961SQLServer7.0SP3December15th,20007.00.1063SQLServer7.0SP48.00.194SQLServer2000RTM8.00.384SQLServer2000SP18.00.534SQLServer2000SP2November30th,20018.00.760SQLServer2000SP38.00.2039SQLServer2000SP4更多的版本对照表：ForSQLServer8MainReleases@@versionVersionandServicePack8.00.2039ServicePack4
8.00.760ServicePack38.00.534ServicePack28.00.384ServicePack18.00.194RTMAllReleases@@versionVersionandServicePack8.00.2039ServicePack48.00.760ServicePack38.00.686SP2+Q3163338.00.679SP2+Q3163338.00.665SP2+Q3163338.00.655SP2+Q3163338.00.650SP2+Q3163338.00.644SP2+Q3241868.00.608SP2+Q316333/Q356326/Q3569388.00.578SP2+Q3163338.00.534ServicePack28.00.532ServicePack2Beta8.00.452SP1+Q3085478.00.444SP1+Q308547/Q3076558.00.443SP1+Q3075388.00.428SP1+Q304850
8.00.384ServicePack18.00.287Q2972098.00.251Q3001948.00.250Q2916838.00.249Q2881228.00.239Q2852908.00.233Q2824168.00.231Q2822798.00.226Q2782398.00.225Q2816638.00.223Q2803808.00.222Q2817698.00.218Q2791838.00.217Q279293/Q2792968.00.211Q2763298.00.210Q2759008.00.205Q2743308.00.204Q2743298.00.194RTM(SQLServer8withnoservicepackapplied)ForSQLServer7MainReleases@@versionVersionandServicePack
7.00.1063SQLServer7withServicePack47.00.961SQLServer7withServicePack37.00.842SQLServer7withServicePack27.00.699SQLServer7withServicePack17.00.623SQLServer7withnoservicepackappliedForSQLServer6.5MainReleases@@versionVersionandServicePack6.50.479SQLServer6.5withServicePack5a(updated)6.50.416SQLServer6.5withServicePack5a.6.50.415SQLServer6.5withServicePack56.50.281SQLServer6.5withServicePack46.50.258SQLServer6.5withServicePack36.50.240SQLServer6.5withServicePack26.50.213SQLServer6.5withServicePack16.50.201SQLServer6.5withnoservicepackappliedForSQLServer6MainReleases@@versionVersionandServicePack6.00.151SQLServer6withServicePack36.00.139SQLServer6withServicePack26.00.124SQLServer6withServicePack1
6.00.121SQLServer6withnoservicepackapplied
