Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'. RRS feed

  • Question

  • I am trying to use ROLLBACK to restore the data to its original status after I have written two SQL codes. I am typing ROLLBACK; in the query and when i click run it gives me this error message:

    Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'.

    Monday, October 20, 2014 4:52 PM

All replies

  • Hi,

    Could you please share the executed SQL codes with us? With the current information, we cannot know what happens.

    Tuesday, October 21, 2014 1:36 AM
  • What type of database are you working with? Also, please post the SQL statement.

    Paul ~~~~ Microsoft MVP (Visual Basic)

    Tuesday, October 21, 2014 5:47 PM