receive statement

接收语句

常用释义

词性释义

接收语句
例句
  • 全部
指定的RECEIVE语句至少修改一行或并将其返回到ServiceBroker队列。
For a given conversation, a RECEIVE statement returns messages with a status of 1 in ascending message_sequence_number order.
对于给定的会话,RECEIVE语句将返回status为1的消息,并将消息按message_sequence_number的升序排列。
If the queue specified in the RECEIVE statement has the queue status set to OFF, the statement fails with a Transact-SQL error.
如果RECEIVE语句指定的队列的队列状态设置为OFF,则该语句将失败,并返回Transact-SQL错误。
RECEIVE语句将锁定返回的消息所属的会话组,直到包含该语句的事务完成为止。
Number of sessions that are currently waiting within a RECEIVE statement for this queue.
当前正在RECEIVE语句中等待此队列的会话数。
Specifies that the RECEIVE statement waits for a message to arrive on the queue, if no messages are currently present.
指定如果当前没有消息,则RECEIVE语句将等待消息到达队列。
此数字包括任何执行接收语句的会话,不管队列监视器是否启动了该会话。
The WHERE clause of the RECEIVE statement may only contain search conditions that use conversation_handle or conversation_group_id.
RECEIVE语句的WHERE子句可能只包含使用conversation_handle或conversation_group_id的搜索条件。
TIMEOUT can be specified in the RECEIVE statement or in the GET CONVERSATION GROUP statement.
可以在RECEIVE语句或GETCONVERSATIONGROUP语句中指定TIMEOUT。
RECEIVE语句将从队列中删除已收到的消息,但队列指定消息保持时除外。
RECEIVE语句返回的所有消息都属于同一个会话组。
If a RECEIVE statement or a GET CONVERSATION GROUP statement specifies an unavailable queue, that statement fails with a Transact-SQL error.
如果RECEIVE语句或GETCONVERSATIONGROUP语句指定了不可用的队列,则该语句将失败,并出现Transact-SQL错误。
要从一个进程内接收一条消息,可使用receive语句。
在receive语句内,使用模式匹配根据消息内容来确定要执行哪些操作。
将RECEIVE语句返回的结果集进行隐式排序。
标记为Initiation的Receive语句:这是我们单元测试启动的目标。
A RECEIVE statement clause, which retrieves one or more messages from a Service Broker queue.
RECEIVE语句子句,从ServiceBroker队列检索一条或多条消息。
When the RETENTION setting for the queue is ON, the RECEIVE statement updates the status column to 1 and leaves the messages in the queue.
当队列的RETENTION设置为ON时,RECEIVE语句将status列更新为1,并使消息留在队列中。
Now create the receive statement to output the message (see Listing 7).
接下来创建receive语句以输出消息(请参见清单7)。
The RECEIVE statement reads messages from a queue and returns a result set.
RECEIVE语句将从队列读取消息并返回结果集。