This shows the license type and number of licenses:

The following example uses the function SERVERPROPERTY in a SELECT statement to return information about the server. This situation is useful when there are multiple instances of SQL Server installed on a Win server, and the customer must open another connection to the same instance used for the current connection.


Or more detail:

SERVERPROPERTY is very interesting system function. It returns many of the system values. I use it very frequently to get different server values like Server Collation, Server Name.