Home Forums Article Discussions Article Discussions by Author Discuss content posted by mike l T-SQL GO statement RE: T-SQL GO statement

  • November 23, 2010 at 9:12 am

    #1254534

    bitbucket-25253 (11/23/2010)

    Hugo Kornelis

    The server does not matter, the client does. You need at least the SSMS version that ships with SQL Server 2005. It should work against any version server, as far as I know (but I never tried this).

    Using SQL 2000 - Query Anayser

    Fails with error message "Incorrect syntax near '100'."

    Using SSM 2005 to connect to same SQL 2000 server

    Executes and returns correct answer.

    Thanks for running the test and confirming what I expected, Ron.

    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/