I need to execute a command string with the use of the Geo command at the end
< Code> exec ('SELECT * FROM tblTmp where id = 1 gO')after my execution
'GO' has the wrong syntax.
If I execute
exec ('SELECT * FROM tblTmp GO') everything is fine
What's the problem here?
Thank you.
You do not need to use GO for a single SQL statement. Only when you are batching several statements in a script, you need to use a separator. In addition, if you are performing these programs, you should use the semicolon (;) statement terminator instead of geo to separate your SQL statement.
This is an easy task.
Comments
Post a Comment