receive statement

接收语句

常用释义

接收语句

例句

A specified RECEIVE statement modifies or returns at least one row to a Service Broker queue.

指定的 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 错误。

The RECEIVE statement locks the conversation group for the messages returned until the transaction that contains the statement completes.

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。

The RECEIVE statement removes received messages from the queue unless the queue specifies message retention.

RECEIVE 语句将从队列中删除已收到的消息，但队列指定消息保持时除外。

All messages returned by a RECEIVE statement belong the same conversation group.

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 错误。

To receive a message from within a process, you use the receive statement.

要从一个进程内接收一条消息，可使用 receive 语句。

Within the receive statement you use pattern matches to determine what to do based on the message content.

在 receive 语句内，使用模式匹配根据消息内容来确定要执行哪些操作。

The result set returned by a RECEIVE statement is implicitly ordered.

将 RECEIVE 语句返回的结果集进行隐式排序。

The Receive statement labelled Initiation: this is the target of our unit test initiation.

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

更新时间：2025-05-16 16:00