共用方式為


UserDefinedFunction.ReturnsNullOnNullInput 屬性

Gets or sets the Boolean property that specifies whether to call the function if at least one of the function arguments is null.

命名空間:  Microsoft.SqlServer.Management.Smo
組件:  Microsoft.SqlServer.Smo (在 Microsoft.SqlServer.Smo.dll 中)

語法

'宣告
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase Or SfcPropertyFlags.Design)> _
Public Property ReturnsNullOnNullInput As Boolean 
    Get 
    Set
'用途
Dim instance As UserDefinedFunction 
Dim value As Boolean 

value = instance.ReturnsNullOnNullInput

instance.ReturnsNullOnNullInput = value
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Design)]
public bool ReturnsNullOnNullInput { get; set; }
[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Standalone|SfcPropertyFlags::SqlAzureDatabase|SfcPropertyFlags::Design)]
public:
property bool ReturnsNullOnNullInput {
    bool get ();
    void set (bool value);
}
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Design)>]
member ReturnsNullOnNullInput : bool with get, set
function get ReturnsNullOnNullInput () : boolean 
function set ReturnsNullOnNullInput (value : boolean)

屬性值

型別:System.Boolean
A Boolean value that specifies whether to call the function if at least one of the function arguments is null.If True, a null is returned without calling the function.If False (default), the function is called even if one of the arguments is null.

範例

設定屬性

請參閱

參考

UserDefinedFunction 類別

Microsoft.SqlServer.Management.Smo 命名空間

其他資源

使用者定義函數 (Database Engine)

CREATE FUNCTION (Transact-SQL)