Thursday, July 7, 2011

Incorrect syntax near “GO”

PROBLEM:
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Incorrect syntax near 'GO'. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

SOLUTION:
1. Put the “GO” command on a new line, separate from the other statement
2. .SqlDataProvider file wasn't encoded in UTF-8 properly. Do save-as, then save file type with encoding UTF-8
3. Check issues with '+' and '-' signs in CREATE PROCEDURE scripts
4. Put an EOF char after the last “GO”


If you find this solution useful, you are welcome to press one of the ads in this page.. Thanks!


No comments:

Post a Comment