查注册表应该是比较简单的办法,例如在 HKEY_LOCAL_MACHINE - Microsoft - Microsoft SQL Server - Instance Names - SQL 下会有一个默认的实例名 SQLEXPRESS,可以此来判断是EXPRESS版本
如何用户在安装SQL时,实例名是自定义的,就找不到 SQLEXPRESS 关键字信息
你也可以参看sql sever 服务名
SELECT SERVERPROPERTY('productversion') as 'Product Version', SERVERPROPERTY('productlevel') as 'Patch Level', SERVERPROPERTY('edition') as 'Product Edition', SERVERPROPERTY('buildclrversion') as 'CLR Version', SERVERPROPERTY('collation') as 'Default Collation', SERVERPROPERTY('instancename') as 'Instance', SERVERPROPERTY('lcid') as 'LCID', SERVERPROPERTY('servername') as 'Server Name'http://hi.baidu.com/liulin0712/item/73a8cbac91da99aa29ce9d41
HKEY_LOCAL_MACHINE - Microsoft - Microsoft SQL Server - Instance Names - SQL 下会有一个默认的实例名 SQLEXPRESS,可以此来判断是EXPRESS版本
如何用户在安装SQL时,实例名是自定义的,就找不到 SQLEXPRESS 关键字信息
SERVERPROPERTY('productversion') as 'Product Version',
SERVERPROPERTY('productlevel') as 'Patch Level',
SERVERPROPERTY('edition') as 'Product Edition',
SERVERPROPERTY('buildclrversion') as 'CLR Version',
SERVERPROPERTY('collation') as 'Default Collation',
SERVERPROPERTY('instancename') as 'Instance',
SERVERPROPERTY('lcid') as 'LCID',
SERVERPROPERTY('servername') as 'Server Name'http://hi.baidu.com/liulin0712/item/73a8cbac91da99aa29ce9d41