September 2010
Intermediate to advanced
1704 pages
111h 8m
English
Queues represent a layer of communication indirection between services, allowing them to send and receive messages independently of each other. A queue is a first-class database object, internally implemented as a table that has some unique behaviors.
You can select values from any queue by using standard syntax, such as SELECT * FROM QueueName WITH (NOLOCK). This has no effect on the data in the queue, nor does it imply a message receive operation. It does, however, cause blocking on the internal queue table, so you should always use the NOLOCK hint. Data Manipulation Language (DML) statements on queues are not permitted.
The following is the syntax for creating a queue:
This syntax contains the following ...