5 / 103
[MS-SSTDS] - v20160510
Tabular Data Stream Protocol Version 4.2
Copyright © 2016 Microsoft Corporation
Release: May 10, 2016
2.2.5.1.1 Least Significant Bit Order ................................................................ 24
2.2.5.2 Data Stream Types ............................................................................... 25
2.2.5.2.1 Unknown-Length Data Streams ......................................................... 25
2.2.5.2.2 Variable-Length Data Streams .......................................................... 25
2.2.5.2.3 Data-Type-Dependent Data Streams .................................................. 26
2.2.5.3 Data Type Definitions ............................................................................ 26
2.2.5.3.1 Fixed-Length Data Types .................................................................. 26
2.2.5.3.2 Variable-Length Data Types .............................................................. 27
2.2.5.4 Data Type Details ................................................................................. 28
2.2.5.4.1 System Data Type Values ................................................................. 28
2.2.5.4.1.1 Integers ................................................................................... 29
2.2.5.4.1.2 Timestamp ................................................................................ 29
2.2.5.4.1.3 Character and Binary Strings ....................................................... 29
2.2.5.4.1.4 Fixed-Point Numbers .................................................................. 29
2.2.5.4.1.5 Floating-Point Numbers .............................................................. 29
2.2.5.4.1.6 Decimal/Numeric ....................................................................... 29
2.2.5.4.1.7 GUID ........................................................................................ 30
2.2.5.4.1.8 Date/Times ............................................................................... 30
2.2.5.5 Type Info Rule Definition ........................................................................ 30
2.2.5.6 Data Buffer Stream Tokens .................................................................... 30
2.2.6 Packet Header Message Type Stream Definition .............................................. 31
2.2.6.1 Bulk Load BCP ...................................................................................... 31
2.2.6.2 Bulk Load Update Text/Write Text ........................................................... 33
2.2.6.3 LOGIN ................................................................................................. 33
2.2.6.4 PRELOGIN ............................................................................................ 37
2.2.6.5 RPC Request......................................................................................... 39
2.2.6.6 SQLBatch ............................................................................................. 41
2.2.6.7 SSPI Message ....................................................................................... 41
2.2.6.8 Transaction Manager Request ................................................................. 42
2.2.7 Packet Data Token Stream Definition ............................................................ 43
2.2.7.1 ALTFMT ............................................................................................... 43
2.2.7.2 ALTNAME ............................................................................................. 45
2.2.7.3 ALTROW .............................................................................................. 46
2.2.7.4 COLINFO .............................................................................................. 47
2.2.7.5 COLFMT ............................................................................................... 48
2.2.7.6 COLNAME ............................................................................................. 50
2.2.7.7 DONE .................................................................................................. 50
2.2.7.8 DONEINPROC ....................................................................................... 52
2.2.7.9 DONEPROC .......................................................................................... 53
2.2.7.10 ENVCHANGE ......................................................................................... 54
2.2.7.11 ERROR ................................................................................................. 55
2.2.7.12 INFO ................................................................................................... 58
2.2.7.13 LOGINACK ........................................................................................... 59
2.2.7.14 OFFSET ................................................................................................ 60
2.2.7.15 ORDER ................................................................................................ 61
2.2.7.16 RETURNSTATUS .................................................................................... 62
2.2.7.17 RETURNVALUE ...................................................................................... 62
2.2.7.18 ROW ................................................................................................... 64
2.2.7.19 SSPI .................................................................................................... 65
2.2.7.20 TABNAME ............................................................................................. 66
2.3 Directory Service Schema Elements ................................................................... 66
3 Protocol Details ..................................................................................................... 67
3.1 Common Details .............................................................................................. 67
3.1.1 Abstract Data Model .................................................................................... 67
3.1.2 Timers ...................................................................................................... 67
3.1.3 Initialization ............................................................................................... 67
3.1.4 Higher-Layer Triggered Events ..................................................................... 67