共用方式為


SetNull 方法

Assigns nullNothingnullptrunitnull 參考 (在 Visual Basic 中為 Nothing) to a buffer column.

命名空間:  Microsoft.SqlServer.Dts.Pipeline
組件:  Microsoft.SqlServer.PipelineHost (在 Microsoft.SqlServer.PipelineHost.dll 中)

語法

'宣告
Public Sub SetNull ( _
    columnIndex As Integer _
)
'用途
Dim instance As PipelineBuffer
Dim columnIndex As Integer

instance.SetNull(columnIndex)
public void SetNull(
    int columnIndex
)
public:
void SetNull(
    int columnIndex
)
member SetNull : 
        columnIndex:int -> unit 
public function SetNull(
    columnIndex : int
)

參數

備註

The SetNull method assigns null Nothing nullptr unit null 參考 (在 Visual Basic 中為 Nothing) to the buffer column specified by the columnIndex parameter.

This method works with the DT_NULL data type in Integration Services.

You can use the SetNull method to insert a null value into a column of any type except for the BLOB data types:

For a complete list of Integration Services data types and the corresponding Get and Set methods of the PipelineBuffer class to use with each type, see 使用資料流程中的資料類型.