RECEIVE doesn't format like SELECT

PDinCA

As SQL Prompt gives us very flexible control over our formatting of SELECT statements, as in comma position, indentation, etc., I was sadly surprised to see that the "equivalent" for Service Broker in the form of the RECEIVE verb, didn't get the love...

WAITFOR (RECEIVE TOP (1)
                  @handle = conversation_handle,
                  @messageType = message_type_name,
                  @messageBody = message_body
                  FROM [target_queue]), TIMEOUT 1000;

Expected something like:

WAITFOR ( RECEIVE TOP (1)
                     @handle      = conversation_handle
                   , @messageType = message_type_name
                   , @messageBody = message_body
                FROM [target_queue]
           ), TIMEOUT 1000;

Any chance RECEIVE can be on par with SELECT, please?

David Priddle

Hi PDinCA,

We are working on a new formatting system at the moment and are working out which features need to be added in through this survey. I've added your request in there, but if you have any other formatting-based suggestions, we'd be very grateful if you could add them in there, to keep them in one place.

Best regards,

David