2.2.7.24 TVP_ROW

Token Stream Name:

 TVP_ROW

Token Stream Function:

Used to send a complete table valued parameter (TVP) row, as defined by the TVP_COLMETADATA token from client to server.

Token Stream Comments:

  • The token value is 0x01/1.

Token Stream-Specific Rules:

 TokenType        =   BYTE
 TvpColumnData    =   TYPE_VARBYTE
 AllColumnData    =   *TvpColumnData

TvpColumnData is repeated once for each column of data with a few exceptions. For details about when certain TvpColumnData items are required to be omitted, see the Flags description of the TVP_COLMETADATA definition (section 2.2.5.5.5.1).

Note that unlike the ROW token, TVP_ROW does not use TextPointer + Timestamp prefix with TEXT, NTEXT and IMAGE types.

Token Stream Definition:

 TVP_ROW              =   TokenType
                          AllColumnData

Token Stream Parameter Details:

Parameter

Description

TokenType

TVP_ROW_TOKEN

TvpColumnData

The actual data for the TVP column. The TYPE_INFO information describing the data type of this data is given in the preceding TVP_COLMETADATA token.