查询MSSQL版本的SQL语句

Written by 正冰 on 2014, May 17, 10:02 AM. 技术归总

刚刚在一台windows2003服务器上安装了mssql2005，为了了解安装最新补丁SQLServer2005sp4前后的变化，在MSSQL查询分析器下测试如下：

打补丁前

  • select @@version
  • Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)   Oct 14 2005 00:33:37   Copyright (c) 1988-2005 Microsoft Corporation  Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2) 

打了SP4补丁后

  • select @@version
  • Microsoft SQL Server 2005 - 9.00.5000.00 (Intel X86)   Dec 10 2010 10:56:29   Copyright (c) 1988-2005 Microsoft Corporation  Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2) 

Tags: windows2003, mssql, sp4

上一篇: Jabra（捷波朗）蓝牙耳机配对方法
下一篇: 解决WDCP后台打不开的问题

相关文章

发表评论


数据库出错:

MySQL Query Error
Mysql error description: Duplicate entry '0' for key 'uid'
Mysql error number: 1062
Date: 2024-06-03 @ 06:00
Script: http://blog.is36.com/index.php/module/action/param1/tagslist/page/3/user/%E6%AD%A3%E5%86%B0/wap/archives/488/archives/463/comments/archives/488/category/technology_all/links/archives/487/date/202302/tagslist/archives/https:/blog.is36.com/index.php/module/action/param1/tagslist/page/3/user/%E6%AD%A3%E5%86%B0/wap/archives/488/archives/463/comments/archives/488/category/technology_all/links/archives/487/date/202302/tagslist/archives/page/4/wap/?action=show&id=366