通过

Trigger.AssemblyName 属性

  • 项目

Gets or sets the name of the .NET assembly that is required by the referenced trigger.

此 API 不符合 CLS。 

命名空间：  Microsoft.SqlServer.Management.Smo
程序集：  Microsoft.SqlServer.Smo（在 Microsoft.SqlServer.Smo.dll 中）

语法

声明
<SfcReferenceAttribute(GetType(SqlAssembly), "Server[@Name = '{0}']/Database[@Name = '{1}']/SqlAssembly[@Name = '{2}']",  _
    )> _
<CLSCompliantAttribute(False)> _
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.Design)> _
Public Property AssemblyName As String 
    Get 
    Set
用法
Dim instance As Trigger 
Dim value As String 

value = instance.AssemblyName

instance.AssemblyName = value

[SfcReferenceAttribute(typeof(SqlAssembly), "Server[@Name = '{0}']/Database[@Name = '{1}']/SqlAssembly[@Name = '{2}']", 
    )]
[CLSCompliantAttribute(false)]
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.Design)]
public string AssemblyName { get; set; }

[SfcReferenceAttribute(typeof(SqlAssembly), L"Server[@Name = '{0}']/Database[@Name = '{1}']/SqlAssembly[@Name = '{2}']", 
    )]
[CLSCompliantAttribute(false)]
[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Standalone|SfcPropertyFlags::Design)]
public:
property String^ AssemblyName {
    String^ get ();
    void set (String^ value);
}

[<SfcReferenceAttribute(typeof(SqlAssembly), "Server[@Name = '{0}']/Database[@Name = '{1}']/SqlAssembly[@Name = '{2}']", 
    )>]
[<CLSCompliantAttribute(false)>]
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.Design)>]
member AssemblyName : string with get, set

function get AssemblyName () : String 
function set AssemblyName (value : String)

属性值

类型：System.String
A String value that specifies the name of the assembly that is required by the referenced trigger.

注释

A value is required for the AssemblyName property only when the ImplementationType property is set to SqlClr.

示例

创建、更改和删除触发器

请参阅

参考

Trigger 类

Microsoft.SqlServer.Management.Smo 命名空间

其他资源

DML 触发器

CREATE TRIGGER (Transact-SQL)