sql - Executing a command string with GO at the end -


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