Export (0) Print
Expand All

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">
   <BufferData>
     <RPCRequest>
       <RPCReqBatch>
         <NameLenProcID>
           <ProcName>
             <US_UNICODE>
               <USHORTLEN>
                 <USHORT>03 00 </USHORT>
               </USHORTLEN>
               <BYTES ascii="f.o.o.">66 00 6F 00 6F 00 </BYTES>
             </US_UNICODE>
           </ProcName>
         </NameLenProcID>
         <OptionFlags>
           <fWithRecomp>
             <BIT>false</BIT>
           </fWithRecomp>
           <fNoMetaData>
             <BIT>false</BIT>
           </fNoMetaData>
           <fReuseMetaData>
             <BIT>false</BIT>
           </fResuseMetaData>
         </OptionFlags>
         <ParameterData>
           <ParamMetaData>
             <B_UNICODE>
               <BYTELEN>
                 <BYTE>00 </BYTE>
               </BYTELEN>
               <BYTES ascii="">
               </BYTES>
             </B_UNICODE>
             <StatusFlags>
               <fByRefValue>
                 <BIT>false</BIT>
               </fByRefValue>
               <fDefaultValue>
                 <BIT>false</BIT>
               </fDefaultValue>
               <fCookie>
                 <BIT>false</BIT>
               </fCookie>
             </StatusFlags>
             <TYPE_INFO>
               <TVP_TYPE_INFO>
                 <TVP_TYPE>
                   <BYTE>F3 </BYTE>
                 </TVP_TYPE>
                 <TVP_TYPE_NAME>
                   <DbName>
                     <B_UNICODE></B_UNICODE>
                   </DbName>
                   <OwningSchema>
                     <B_UNICODE>dbo</B_UNICODE>
                   </OwningSchema>
                   <TypeName>
                     <B_UNICODE>tvptype</B_UNICODE>
                   </TypeName>
                 </TVP_TYPE_NAME>
                 <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_UNICODE>
                         <BYTELEN>
                           <BYTE>00 </BYTE>
                         </BYTELEN>
                         <BYTES ascii="">
                         </BYTES>
                       </B_UNICODE>
                     </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>
             </TYPE_INFO>
           </ParamMetaData>
           <ParamLenData>
           </ParamLenData>
         </ParameterData>
       </RPCReqBatch>
     </RPCRequest>
   </BufferData>
 </tds>
Show:
© 2016 Microsoft