sql-server - 检查SQL Server数据库上的托管程序集版本

Question

我需要找出部署到SQL Server数据库的程序集的版本。
我需要通过脚本或其他编程方式来执行此操作，以了解是否需要重新部署程序集。

有任何想法吗？

谢谢。

Answer 1

这应该有所帮助。

Syntax
ASSEMBLYPROPERTY('assembly_name', 'property_name')
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
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.