Section courante

A propos

Section administrative du site

RECEIVE

Recevoir
  Microsoft SQL Server

Syntaxe

[ WAITFOR ( ]
RECEIVE [ TOP ( n ) ]
column_specifier [ ,...n ]
FROM queue
[ INTO table_variable ]
[ WHERE { conversation_handle = conversation_handle
| conversation_group_id = conversation_group_id } ]
[ ) ] [ , TIMEOUT timeout ]
[ ; ]

column_specifier ::=
{ *
| { column_name | [ ] expression } [ [ AS ] column_alias ]
| column_alias = expression
} [ ,...n ]

queue ::=
{ database_name.schema_name.queue_name | schema_name.queue_name | queue_name }

Description

Cette instruction permet de recevoir un ou plusieurs messages de la file d'attente.



Dernière mise à jour : Vendredi, le 19 Juin 2020