Поделиться через


Метод SetNull

Assigns nullNothingnullptrunitпустая ссылка (Nothing в Visual Basic) 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 пустая ссылка (Nothing в Visual Basic) 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 Работа с типами данных в потоке данных.