Hello Guys, Lately, one of my friend asked me a Question, "If Delete is in progress and query get erred out or Timeout, will already deleted data will be rolled back, considering we do not have any transaction? " My previous Answer was NO, After I executed the below statements. I will create two tables, PkTable – Having … Continue reading Consequences of Timeout/Error on a Delete statement
It seems to be the most basic thing but this post is specifically to those who have just started or want to start their career in Database Domain. When you are a novice. You have only idea about what is a Database. But in practical life how companies are actually managing it? Let us start with … Continue reading A Basic Introduction of Database, Tables and SQL.