4.14 TVP Insert Statement
TVP insert statement sent from client to server:
-
03 01 00 52 00 00 01 00 16 00 00 00 12 00 00 00 02 00 00 00 00 00 00 00 00 00 00 00 00 01 03 00 66 00 6F 00 6F 00 00 00 00 00 F3 00 03 64 00 62 00 6F 00 07 74 00 76 00 70 00 74 00 79 00 70 00 65 00 01 00 00 00 00 00 00 00 26 01 00 00 01 01 02 00 <tds version="katmai"> <PacketHeader> <Type> <BYTE>03 </BYTE> </Type> <Status> <BYTE>01 </BYTE> </Status> <Length> <BYTE>00 </BYTE> <BYTE>52 </BYTE> </Length> <SPID> <BYTE>00 </BYTE> <BYTE>00 </BYTE> </SPID> <PacketID> <BYTE>01 </BYTE> </PacketID> <Window> <BYTE>00 </BYTE> </Window> </PacketHeader> <PacketData> <RPCRequest> <All_HEADERS> <TotalLength> <DWORD>16 00 00 00 </DWORD> </TotalLength> <Header> <HeaderLength> <DWORD>12 00 00 00 </DWORD> </HeaderLength> <HeaderType> <USHORT>02 00 </USHORT> </HeaderType> <HeaderData> <MARS> <TransactionDescriptor> <ULONGLONG>00 00 00 00 00 00 00 00 </ULONGLONG> </TransactionDescriptor> <OutstandingRequestCount> <DWORD>00 00 00 01 </DWORD> </OutstandingRequestCount> </MARS> </HeaderData> </Header> </All_HEADERS> <RPCReqBatch> <NameLenProcID> <ProcName> <US_VARCHAR> <USHORTLEN>03 00 </USHORTLEN> <BYTES ascii="f.o.o.">66 00 6F 00 6F 00 </BYTES> </US_VARCHAR> </ProcName> </NameLenProcID> <OptionFlags> <fWithRecomp> <BIT>0</BIT> </fWithRecomp> <fNoMetaData> <BIT>0</BIT> </fNoMetaData> <fReuseMetaData> <BIT>0</BIT> </fReuseMetaData> </OptionFlags> <ParameterData> <ParamMetaData> <B_VARCHAR> <BYTELEN>00 </BYTELEN> <BYTES ascii=""> </BYTES> </B_VARCHAR> <StatusFlags> <fByRefValue> <BIT>0</BIT> </fByRefValue> <fDefaultValue> <BIT>0</BIT> </fDefaultValue> <fEncrypted> <BIT>0</BIT> </fEncrypted> </StatusFlags> <TVP_TYPE_INFO> <TVPTYPE> <BYTE>F3 </BYTE> </TVPTYPE> <TVP_TYPENAME> <DbName> <B_VARCHAR> <BYTELEN> <BYTE>00 </BYTE> </BYTELEN> <BYTES ascii=""> </BYTES> </B_VARCHAR> </DbName> <OwningSchema> <B_VARCHAR> <BYTELEN> <BYTE>03 </BYTE> </BYTELEN> <BYTES ascii="dbo">64 00 62 00 6F 00 </BYTES> </B_VARCHAR> </OwningSchema> <TypeName> <B_VARCHAR> <BYTELEN> <BYTE>07 </BYTE> </BYTELEN> <BYTES ascii="tvptype">74 00 76 00 70 00 74 00 79 00 70 00 65 00 </BYTES> </B_VARCHAR> </TypeName> </TVP_TYPENAME> <TVP_COLMETADATA> <Count> <USHORT>01 00 </USHORT> </Count> <TvpColumnMetaData> <UserType> <ULONG>00 00 00 00 </ULONG> </UserType> <Flags> <USHORT>00 00 </USHORT> </Flags> <TYPE_INFO> <VARLENTYPE> <BYTELEN_TYPE> <BYTE>26 </BYTE> </BYTELEN_TYPE> </VARLENTYPE> <TYPE_VARLEN> <BYTELEN> <BYTE>01 </BYTE> </BYTELEN> </TYPE_VARLEN> </TYPE_INFO> <ColName> <B_VARCHAR> <BYTELEN> <BYTE>00 </BYTE> </BYTELEN> <BYTES ascii=""> </BYTES> </B_VARCHAR> </ColName> </TvpColumnMetaData> </TVP_COLMETADATA> <TVP_END_TOKEN> <TokenType> <BYTE>00 </BYTE> </TokenType> </TVP_END_TOKEN> <TVP_ROW> <TokenType> <BYTE>01 </BYTE> </TokenType> <AllColumnData> <TYPE_VARBYTE> <TYPE_VARLEN> <BYTELEN> <BYTE>01</BYTE> </BYTELEN> <BYTES>02</BYTES> </TYPE_VARLEN> </TYPE_VARBYTE> </AllColumnData> </TVP_ROW> <TVP_END_TOKEN> <TokenType> <BYTE>00 </BYTE> </TokenType> </TVP_END_TOKEN> </TVP_TYPE_INFO> </ParamMetaData> <ParamLenData> </ParamLenData> </ParameterData> </RPCReqBatch> </RPCRequest> </PacketData> </tds>