What are the challenges you face when working across database platforms? Take the survey
Options

RECEIVE doesn't format like SELECT

PDinCAPDinCA Posts: 642 Silver 1
edited March 3, 2015 10:18AM in SQL Prompt
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?
Jesus Christ: Lunatic, liar or Lord?
Decide wisely...

Comments

  • Options
    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
Sign In or Register to comment.