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语句将从队列读取消息并返回结果集。