Misfits converge.
... think about it ...
Posts
The One about Bingeworthy Shows
3 years ago
20071026
20071008
GO speedracer GO
PRINT 'Here is a test'
/*
Here is a place for a comment to
GO
*/
The commented GO statement within the /* */ still executes and as such will cause a syntax error. This is corrected in 2005 servers but you will have to watch out for it on current boxes.
Update August fifthe 2009
We got hit by this again so I did some further experiments. Turns out it is related to the OSQL/ISQLW/ISQL installed and not the server. You can run this same script from a machine with the 2005 tools installed and point to the 2000 server and there is no error.
Point is then, when you are testing for compatibility of your scripts, don't run it from the 2005 management studio. You will get a false positive.
/*
Here is a place for a comment to
GO
*/
The commented GO statement within the /* */ still executes and as such will cause a syntax error. This is corrected in 2005 servers but you will have to watch out for it on current boxes.
Update August fifthe 2009
We got hit by this again so I did some further experiments. Turns out it is related to the OSQL/ISQLW/ISQL installed and not the server. You can run this same script from a machine with the 2005 tools installed and point to the 2000 server and there is no error.
Point is then, when you are testing for compatibility of your scripts, don't run it from the 2005 management studio. You will get a false positive.
Subscribe to:
Posts (Atom)
License & copyright
StinkySQL weblog and any related pages, including the weblog's archives are licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 United States License.
