select SERVERPROPERTY ('Edition')


SERVERPROPERTY
Returns property information about the server instance.

Syntax
SERVERPROPERTY (propertyname )

Arguments
propertyname

Is an expression containing the property information to be returned for the server. propertyname can be one of these values.

参见msdn：http://msdn.microsoft.com/en-us/library/aa259183(SQL.80).aspx