Post reply

Batch Separator (is it possible?)

  • July 11, 2003 at 11:47 am

    #106699

    Is it possible to change the "Batch Separator" value from T-SQL?

    This "Batch Separator" value can be found under the following menu within SQL Analyzer:

    TOOLS --> Options --> Connections

    Thanks in advance,

    Billy

    Edited by - bp on 07/11/2003 11:47:37 AM

  • July 11, 2003 at 12:12 pm

    #465136

    The batch separator only applies to the client. What Query Analyzer does is it recognizes the batch separator and that determines how it breaks up its submissions to SQL Server. It's not germane to the server itself.

    So if I do the following:

    SELECT @@VERSION

    GO

    SELECT @@SERVERNAME

    What happens is Query Analyzer first executes SELECT @@VERSION as the first batch. Then it exeutes SELECT @@SERVERNAME as the second batch. This is entirely within Query Analyzer. SQL Server receives them as two separate and distinct batches.

    K. Brian Kelley

    http://www.truthsolutions.com/

    Author: Start to Finish Guide to SQL Server Performance Monitoring

    http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

    K. Brian Kelley
    @kbriankelley

  • July 14, 2003 at 8:30 am

    #465343

    A followup question - in QA, will queries separated by the batch separator run consecutively or concurrently? In other words, can I rely on the first being complete before the second begins?

    thanks

    k2

  • July 14, 2003 at 8:52 am

    #465351

    It should keep the order intact.

    K. Brian Kelley

    http://www.truthsolutions.com/

    Author: Start to Finish Guide to SQL Server Performance Monitoring

    http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

    K. Brian Kelley
    @kbriankelley

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply