The 365 Data Science team is proud to invite you to our own community forum. A very well built system to support your queries, questions and give the chance to show your knowledge and help others in their path of becoming Data Science specialists.
Ask
Anybody can ask a question
Answer
Anybody can answer
Vote
The best answers are voted up and moderated by our team

Commit and Rollback Statement in SQL

Back to all questions

Commit and Rollback Statement in SQL

Super Learner 8 months ago
Vote Up Vote Down
0
Votes
1
Answer

Hi everyone ,  even though i follow the course to the letter , when i use the commit statement and after some changes i make to the database i use the rollback in order to get back to the version of the database  i saved ,  it is not taking me there . It is like i have never used the commit statement . Any reasons why is that ? 

1 Answer

365 Team 8 months ago
Vote Up Vote Down
0
Votes

Hi Vangelis!
Thanks for reaching out!
Can you please verify whether you have “un-ticked” the Safe Updates option from the Edit/Preferences/SQL Editor window?

After you’ve done that, please reconnect to the database by pressing this icon. Finally, if this doesn’t help, you can restart Workbench.

Hope this helps but please feel free to get back to us (with additional information, please) should you need further assistance. Thank you.
Best,
Martin

You must to answer this question.