Returns information about a property of an assembly.
Is the name of the assembly.
Is the name of a property about which to retrieve information. property_name can be one of the following values.
Locale of the assembly.
Public key or public key token of the assembly.
Complete, compiler-generated version identification number of the assembly.
Major component (first part) of the four-part version identification number of the assembly.
Minor component (second part) of the four-part version identification number of the assembly.
Build component (third part) of the four-part version identification number of the assembly.
Revision component (fourth part) of the four-part version identification number of the assembly.
Simple name of the assembly.
Processor architecture of the assembly.
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.
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');