Post reply

TSQL Command separators or delimiters

  • March 17, 2005 at 7:06 am

    #102441

    Does anyone have a list of valid command separators or delimiters recognized by the Query Analyzer parser?

    The ones I believe work within a batch are the following single characters and their combinations:  space, newline, carriage return.

    What about other non-printable characters such as Null, EOT, etc.?

     

    [font="Arial"]Clifton G. Collins III[/font]

  • March 18, 2005 at 5:49 am

    #547753

    the semicolon is also recognized as a command separator, if that helps.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • March 18, 2005 at 9:19 am

    #547809

    Updated set of TSQL command separators:

    space, 32d

    tab, 09d

    newline, 10d

    carriage return, 13d

    semicolon, 59d

     

    [font="Arial"]Clifton G. Collins III[/font]

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

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