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

GO xxx

fatherjack2fatherjack2 Posts: 311
edited February 16, 2009 4:48AM in SQL Multi Script
Hi,

SQL MultiScript seems to have a problem when a script has a GO statement with a number following it
eg:
SELECT GETDATE()
GO 15

I think SQL Prompt has problems too ...

Regards

Jonathan

Senior DBA
Careers South West Ltd

Comments

  • Options
    Hi Father Jack,

    the batch separator (which is configured by default to be GO) and its relating syntax are not features of SQL Server. They are entirely part of SQL Server Management Studio.

    As such, we decided support batch separators, but we have chosen not to support the <batch separator> nnn syntax.

    This is already listed in our bug track system as issue SE-395

    Cheers,
    --
    Daniel
Sign In or Register to comment.