Anteckning
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
Applies to: 
SQL Server
Azure SQL Managed Instance
This function returns information about a property of an assembly.
Transact-SQL syntax conventions
Syntax
ASSEMBLYPROPERTY('assembly_name', 'property_name')
Arguments
assembly_name
The name of the assembly.
property_name
The name of a property about which to retrieve information. property_name can have 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. |
Return type
sql_variant
Examples
This example assumes a HelloWorld assembly that is registered in the AdventureWorks2022 database. For more information, see Hello World Sample.
USE AdventureWorks2022;
GO
SELECT ASSEMBLYPROPERTY ('HelloWorld' , 'PublicKey');