16 / 103
[MS-SSTDS] - v20160510
Tabular Data Stream Protocol Version 4.2
Copyright © 2016 Microsoft Corporation
Release: May 10, 2016
2.2.2.4 Return Status
When a stored procedure is executed by the server, the server must return a status value. This is a 4-
byte integer and is sent via the RETURNSTATUS token. A stored procedure execution is requested
through either an RPC Batch or SQL Batch message. For additional information, see section 2.2.7.16.
2.2.2.5 Return Parameters
The response format for execution of a stored procedure is identical regardless of whether the request
was sent as SQL Batch or RPC Batch. It is always a tabular result-type message.
The procedure can explicitly send any data, including row data, informational messages, and error
messages. This data is sent in the usual way.
When the RPC is invoked, some or all of its parameters are designated as output parameters. All
output parameters have values returned from the server. For each output parameter, there is a
corresponding return value that is sent via the RETURNVALUE token. The RETURNVALUE token data
stream is also used for sending back the value returned by a user-defined function (UDF), if it is called
as an RPC. For additional details about the RETURNVALUE token, see section 2.2.7.17.
2.2.2.6 Response Completion (DONE)
The client reads results in logical units and can determine when all results have been received by
examining the DONE token data stream.
When executing a batch of SQL statements, the server MUST return a DONE token data stream for
each set of results. All but the last DONE will have the DONE_MORE bit set in the Status field of the
DONE token data stream. Therefore, the client can always determine after reading a DONE whether
there are more results. For additional details about the DONE token, see section 2.2.7.7.
For stored procedures, completion of SQL statements in a stored procedure is indicated by a
DONEINPROC token data stream<2> for each SQL statement and a DONEPROC token data stream for
each completed stored procedure. For additional details about DONEINPROC and DONEPROC tokens,
see sections 2.2.7.8 and 2.2.7.9, respectively.
2.2.2.7 Error and Info Messages
Besides returning a description of row data and the data itself, TDS 4.2 provides a token data stream
type for the server to send error or informational messages to the client. These are the INFO token
data stream, described in section 2.2.7.12 and the ERROR token data stream, described in section
2.2.7.11.
2.2.2.8 Attention Acknowledgment
After a client has sent an interrupt signal to the server, the client MUST read returning data until the
interrupt has been acknowledged. Attentions are acknowledged in the DONE token data stream,
described in section 2.2.7.7.
2.2.3 Packets
A packet is the unit written or read at one point in time. A message may consist of one or more
packets. A packet always includes a packet header and is usually followed by packet data that
contains the message. Each new message starts in a new packet.
In practice, both the client and server will try to read a packet full of data. They will pick out the
header to see how much more (or less) data there is in the communication.
剩余102页未读，继续阅读
blowmoon
- 粉丝: 2
- 资源: 1
我的内容管理
展开
最新资源
- 多模态联合稀疏表示在视频目标跟踪中的应用
- Kubernetes资源管控与Gardener开源软件实践解析
- MPI集群监控与负载平衡策略
- 自动化PHP安全漏洞检测：静态代码分析与数据流方法
- 青苔数据CEO程永：技术生态与阿里云开放创新
- 制造业转型： HyperX引领企业上云策略
- 赵维五分享：航空工业电子采购上云实战与运维策略
- 单片机控制的LED点阵显示屏设计及其实现
- 驻云科技李俊涛：AI驱动的云上服务新趋势与挑战
- 6LoWPAN物联网边界路由器：设计与实现
- 猩便利工程师仲小玉：Terraform云资源管理最佳实践与团队协作
- 类差分度改进的互信息特征选择提升文本分类性能
- VERITAS与阿里云合作的混合云转型与数据保护方案
- 云制造中的生产线仿真模型设计与虚拟化研究
- 汪洋在PostgresChina2018分享：高可用 PostgreSQL 工具与架构设计
- 2018 PostgresChina大会：阿里云时空引擎Ganos在PostgreSQL中的创新应用与多模型存储
资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！
点击此处反馈
