On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?
- 1 Answers
- 1090 Views
- I also Faced
- E-Mail Answers
Answer Posted / Vipul Negi
The data might not have persisted due to a database crash or an issue with transaction management. When performing multiple INSERT statements without explicitly starting a transaction and committing it, the data may only exist in memory and could be lost if something goes wrong before committing the changes.nnTo prevent such issues, always use transactions by surrounding your operations inside BEGIN TRANSACTION, COMMIT, or ROLLBACK statements.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
