RECEIVE doesn't format like SELECT

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 &#91;target_queue&#93;), TIMEOUT 1000;

Expected something like:

WAITFOR ( RECEIVE TOP (1)
                     @handle      = conversation_handle
                   , @messageType = message_type_name
                   , @messageBody = message_body
                FROM &#91;target_queue&#93;
           ), TIMEOUT 1000;

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

PDinCA March 02, 2015 20:17

Comments

1 comment

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

David Priddle March 03, 2015 10:18

0

Add comment

Please sign in to leave a comment.

How can we help you today?

RECEIVE doesn't format like SELECT

Comments

Add comment