如题:
怎么判断我的SQL Server 2005的版本?企业版还是开发版,SP1还是SP2
------解决方案--------------------
SELECT SERVERPROPERTY('productversion'),SERVERPROPERTY('productlevel'),SERVERPROPERTY('edition')
------解决方案--------------------
- SQL code
--数据库的版本select @@version/*Microsoft SQL Server 2005 - 9.00.2050.00 (Intel X86) Feb 13 2007 23:02:48 Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows NT 5.2 (Build 3790: Service Pack 2, v.2825)(1 row(s) affected)