版本识别
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
显示
8.00.760 SP3 Enterprise Edition
SELECT @@VERSION
显示
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
我知道760是sp3,但(Build 3790: Service Pack 2)说的是什么的版本呢,不懂请大家指教