How can we help you today? How can we help you today?

SQL Batch integer causes syntax error

I know its not SQL standard but the SSMS UI allows for the GO keyword to have an integer after it so that a section of code can be repeated a given number of times eg:

select top 3 * from sales
GO 10

SQL Prompt underlines the '10' and wont layout the code
(neither will SQL Refactor I notice ...)

regards

Jonathan
fatherjack2
0

Comments

2 comments

Sort by
  • simon.jackson
    Ohh, I didn't know you could do that! Sounds handy. Thanks for reporting the bug. I've raised it in our issue tracking system and we'll look at fixing it in a future release.


    Simon
    simon.jackson
    0
  • fatherjack2
    Hi Simon,

    Just to let you know, it also fails in SQL MultiScript too but that seemed to be by design rather than it not being encountered by the response I got when I mentioned it a while back.

    regards

    Jonathan
    fatherjack2
    0

Add comment

Please sign in to leave a comment.