共用方式為

ProtocolField.SqlExpression Property

  • 發行項

Gets or sets the Transact-SQL expression that computes the protocol field value.

命名空間: Microsoft.SqlServer.Management.Nmo
組件: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

語法

'宣告
Public Property SqlExpression As String

public string SqlExpression { get; set; }

public:
property String^ SqlExpression {
    String^ get ();
    void set (String^ value);
}

/** @property */
public String get_SqlExpression ()

/** @property */
public void set_SqlExpression (String value)

public function get SqlExpression () : String

public function set SqlExpression (value : String)

屬性值

A String, between 0 and 4000 characters in length, that specifies the Transact-SQL statement that computes the field value.

備註

A Transact-SQL expression is a combination of identifiers, values, and operators that the Database Engine can evaluate to get a result. You can use any expression that can be part of a SELECT statement. The terms of the expression can be any of the following:

  • Constants.

  • Calls to functions.

  • The notification fields defined in the ADF (but not computed fields).

  • The following built-in notification fields:

    • SubscriberId

    • DeviceName

    • DeviceTypeName

    • DeviceAddress

    • SubscriberLocale

    • DeliveryChannelName

For more information, see 運算式 (Database Engine).

Enclose string constants in single quotation marks.

If the ProtocolField does not use a SqlExpression property it must use a FieldReference property instead.

範例

The following examples show how to define a protocol field that uses a Transact-SQL expression to generate the protocol field value:

ProtocolField smtpProtocolField1 = 
    new ProtocolField(smtpProtocol, "Subject");
smtpProtocolField1.SqlExpression = 
    "'Flight notification: '+CONVERT (NVARCHAR(30), GETDATE())";
smtpProtocol.ProtocolFields.Add(smtpProtocolField1);

Dim smtpProtocolField1 As ProtocolField = _
    New ProtocolField(smtpProtocol, "Subject")
smtpProtocolField1.SqlExpression = _
    "'Flight notification: '+CONVERT (NVARCHAR(30), GETDATE())"
smtpProtocol.ProtocolFields.Add(smtpProtocolField1)

執行緒安全性

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

平台

開發平台

如需受支援的平台清單，請參閱＜安裝 SQL Server 2005 的硬體和軟體需求＞。

目標平台

如需受支援的平台清單，請參閱＜安裝 SQL Server 2005 的硬體和軟體需求＞。

請參閱

參考

ProtocolField Class
ProtocolField Members
Microsoft.SqlServer.Management.Nmo Namespace

其他資源

Protocol Element (ADF)
SqlExpression Element for Protocol/Fields/Field (ADF)