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
Phản hồi
https://aka.ms/ContentUserFeedback.
Sắp ra mắt: Trong năm 2024, chúng tôi sẽ dần gỡ bỏ Sự cố với GitHub dưới dạng cơ chế phản hồi cho nội dung và thay thế bằng hệ thống phản hồi mới. Để biết thêm thông tin, hãy xem:Gửi và xem ý kiến phản hồi dành cho