Temporal features and temporal tables clearly explained and with examples! (Special: WHO'S WHO in the SQL world pt/2.. Mr. Krishna Kulkarni)
Hi guys, Welcome to this new post! This time we will talk about temporal features and temporal table (attention please... not temporary tables). We never talked about this topic in this blog but today is the right day to do it! Why is this an important topic? Well, how many times you had to track changes in data contained into a table? I am sure, so many times! Probably you solved this problem of tracking changes to your data (and so to know what happened to your data in the past) using triggers. A trigger is fired every time the value of a field in a table change. This trigger will add a row into a log table. It is necessary to know that this operation is natively supported by many database systems and also our Microsoft SQL Server has been supporting it for several years. Enjoy the reading! SQL:2011 and the Temporal Features. A Bit of Theory. We start talking about temporal tables by saying that they are supported by different database engines because they have been defined as