ASSEMBLYPROPERTY (Transact-SQL)
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')
Note
To view Transact-SQL syntax for SQL Server 2014 (12.x) and earlier versions, see Previous versions documentation.
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');
See also
Feedback
https://aka.ms/ContentUserFeedback.
În curând: Pe parcursul anului 2024, vom elimina treptat Probleme legate de GitHub ca mecanism de feedback pentru conținut și îl vom înlocui cu un nou sistem de feedback. Pentru mai multe informații, consultați:Trimiteți și vizualizați feedback pentru