Professional Web Applications Themes

parsing bug? - Microsoft SQL / MS SQL Server

this works ------BEGIN SQL------- CREATE PROCEDURE [tmpBug] AS DECLARE SQL varchar(1000) SET SQL = ' test ' SELECT SQL ------END SQL------- this gives the error message Error 105: Unclosed quatation mark before the character string ''. Line 5: Incorrect syntax near ''. ------BEGIN SQL------- CREATE PROCEDURE [tmpBug] AS DECLARE SQL varchar(1000) SET SQL = ' GO ' SELECT SQL ------END SQL-------...

  1. #1

    Default parsing bug?

    this works
    ------BEGIN SQL-------
    CREATE PROCEDURE [tmpBug]
    AS

    DECLARE SQL varchar(1000)
    SET SQL = '
    test
    '
    SELECT SQL
    ------END SQL-------

    this gives the error message
    Error 105: Unclosed quatation mark before the character string ''.
    Line 5: Incorrect syntax near ''.

    ------BEGIN SQL-------
    CREATE PROCEDURE [tmpBug]
    AS

    DECLARE SQL varchar(1000)
    SET SQL = '
    GO
    '
    SELECT SQL
    ------END SQL-------

    Bob Guest

  2. #2

    Default Re: parsing bug?

    Bob,

    GO

    is a batch separator in T-SQL. Your failing example is
    interpreted exactly as if you sent what's above GO by itself,
    followed by what's below GO.

    Batch 1:

    CREATE PROCEDURE [tmpBug]
    AS

    DECLARE SQL varchar(1000)
    SET SQL = '


    Batch 2:

    '
    SELECT SQL


    Neither of these two batches has correct syntax. Basically,
    don't put GO on a line by itself in a stored procedure, in
    a multi-line comment, or in a multiline string.

    -- Steve Kass
    -- Drew University
    -- Ref: AA59FB82-4C7F-4DF2-A053-ABC0D79C2FE9

    Bob wrote:
     

    Steve Guest

  3. #3

    Default Re: parsing bug?

    This is not bug. your first stored procedure will get created because there
    is no batch terminator GO and it assumes to be the whole batch. whereas in
    case of your second stored procedure you are mentioning GO because of which
    "create procedure" statement ends at

    SET SQL = '

    This is an incomplete single quote.

    --
    -Vishal
    "Bob" <net> wrote in message
    news:phx.gbl... 


    Vishal Guest

  4. #4

    Default Re: parsing bug?

    A formal system with symbols of higher precedence that its literal delimeters? I
    wonder what Gödel would have said about that.

    Thanks,
    Bob

    "Steve Kass" <edu> wrote in message
    news:phx.gbl... 
    >[/ref]

    Bob Guest

  5. #5

    Default Re: parsing bug?

    Jacco,

    Thanks for the catch! By the way, the batch
    separator is configurable in the Query yzer
    options - connection tab. If you like practical jokes,
    try changing it to something like SELECT when a co-worker
    leaves their workstation unattended.

    SK

    Jacco Schalkwijk wrote:
     
    >delimeters? I
    >
    > [/ref]
    >
    >
    >
    >[/ref]

    Steve Guest

Similar Threads

  1. Parsing U3D
    By Kenney_Wong@adobeforums.com in forum Adobe Acrobat SDK
    Replies: 2
    Last Post: February 25th, 03:18 PM
  2. parsing XML
    By zoom4267 in forum Macromedia Flex General Discussion
    Replies: 4
    Last Post: July 24th, 08:14 PM
  3. PDF Parsing
    By Tamir_Noach@adobeforums.com in forum Adobe Acrobat SDK
    Replies: 1
    Last Post: December 31st, 07:04 PM
  4. XML Parsing
    By Doug La Farge in forum PHP Programming
    Replies: 13
    Last Post: July 12th, 06:03 PM
  5. Parsing EPS
    By Linza@adobeforums.com in forum Adobe Illustrator Macintosh
    Replies: 4
    Last Post: April 21st, 05:36 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139