This topic has not yet been rated - Rate this topic

4.5 SQL Batch Server Response

Server response sent from the server to the client:

04 01 00 33 00 00 01 00 81 01 00 00 00 00 00 20 
00 A7 03 00 09 04 D0 00 34 03 62 00 61 00 72 00 
D1 03 00 66 6F 6F FD 10 00 C1 00 01 00 00 00 00 
00 00 00
  <PacketHeader>
    <Type>
      <BYTE>04 </BYTE>
    </Type>
    <Status>
      <BYTE>01 </BYTE>
    </Status>
    <Length>
      <BYTE>00 </BYTE>
      <BYTE>33 </BYTE>
    </Length>
    <SPID>
      <BYTE>00 </BYTE>
      <BYTE>00 </BYTE>
    </SPID>
    <Packet>
      <BYTE>01 </BYTE>
    </Packet>
    <Window>
      <BYTE>00 </BYTE>
    </Window>
  </PacketHeader>
  <PacketData>
    <TableResponse>
      <COLMETADATA>
        <TokenType>
          <BYTE>81 </BYTE>
        </TokenType>
        <Count>
          <USHORT>01 00 </USHORT>
        </Count>
        <ColumnData>
          <UserType>
            <ULONG>00 00 00 00 </ULONG>
          </UserType>
          <Flags>
            <USHORT>20 00 </USHORT>
          </Flags>
          <TYPE_INFO>
            <VARLENTYPE>
              <USHORTLEN_TYPE>
                <BYTE>A7 </BYTE>
              </USHORTLEN_TYPE>
            </VARLENTYPE>
            <TYPE_VARLEN>
              <USHORTCHARBINLEN>
                <USHORT>03 00 </USHORT>
              </USHORTCHARBINLEN>
            </TYPE_VARLEN>
            <COLLATION>
              <BYTES>09 04 D0 00 34 </BYTES>
            </COLLATION>
          </TYPE_INFO>
          <ColName>
            <B_UNICODE>
              <BYTELEN>
                <BYTE>03 </BYTE>
              </BYTELEN>
              <BYTES ascii="b.a.r.">62 00 61 00 72 00 </BYTES>
            </B_UNICODE>
          </ColName>
        </ColumnData>
      </COLMETADATA>
      <ROW>
        <TokenType>
          <BYTE>D1 </BYTE>
        </TokenType>
        <TYPE_VARBYTE>
          <TYPE_VARLEN>
            <USHORTCHARBINLEN>
              <USHORT>03 00 </USHORT>
            </USHORTCHARBINLEN>
          </TYPE_VARLEN>
          <BYTES ascii="foo">66 6F 6F </BYTES>
        </TYPE_VARBYTE>
      </ROW>
      <DONE>
        <TokenType>
          <BYTE>FD </BYTE>
        </TokenType>
        <Status>
          <USHORT>10 00 </USHORT>
        </Status>
        <CurCmd>
          <USHORT>C1 00 </USHORT>
        </CurCmd>
        <DoneRowCount>
          <LONGLONG>01 00 00 00 00 00 00 00 </LONGLONG>
        </DoneRowCount>
      </DONE>
    </TableResponse>
  </PacketData>
 
Did you find this helpful?
(1500 characters remaining)
© 2013 Microsoft. All rights reserved.