CREATE QUEUE |
Crée une queue |
|---|---|
| Microsoft SQL Server |
Syntaxe
|
CREATE QUEUE object [ WITH [ STATUS = { ON | OFF } [ , ] ] [ RETENTION = { ON | OFF } [ , ] ] [ ACTIVATION ( [ STATUS = { ON | OFF } , ] PROCEDURE_NAME = procedure , MAX_QUEUE_READERS = max_readers , EXECUTE AS { SELF | 'user_name' | OWNER } ) [ , ] ] [ POISON_MESSAGE_HANDLING ( [ STATUS = { ON | OFF } ] ) ] ] [ ON { filegroup | [ DEFAULT ] } ] [ ; ] object ::= { database_name.schema_name.queue_name | schema_name.queue_name | queue_name } procedure ::= { database_name.schema_name.stored_procedure_name | schema_name.stored_procedure_name | stored_procedure_name } |
Description
Cette instruction permet de créer une nouvelle file d'attente dans la base de données.
Dernière mise à jour : Vendredi, le 19 Juin 2020