ASSEMBLYPROPERTY (Transact-SQL)

assembly_name

Is the name of the assembly.

property_name

Is the name of a property about which to retrieve information. property_name can be one of the following values.

Value	Description
CultureInfo	Locale of the assembly.
PublicKey	Public key or public key token of the assembly.
MvID	Complete, compiler-generated version identification number of the assembly.
VersionMajor	Major component (first part) of the four-part version identification number of the assembly.
VersionMinor	Minor component (second part) of the four-part version identification number of the assembly.
VersionBuild	Build component (third part) of the four-part version identification number of the assembly.
VersionRevision	Revision component (fourth part) of the four-part version identification number of the assembly.
SimpleName	Simple name of the assembly.
Architecture	Processor architecture of the assembly.
CLRName	Canonical string that encodes the simple name, version number, culture, public key, and architecture of the assembly. This value uniquely identifies the assembly on the common language runtime (CLR) side.

sql_variant

The following example assumes that the SQL Server Database Engine samples are installed on the local computer and the HelloWorld assembly is registered in the AdventureWorks2008R2 database. For more information, see Considerations for Installing SQL Server Samples and Sample Databases.

USE AdventureWorks2008R2;
GO
SELECT ASSEMBLYPROPERTY ('HelloWorld' , 'PublicKey');

Reference