In last TIP #78 we have discussed Change tracker (CT) which was introduced in SQL SERVER 2008. CT feature only tracks which row is changes means on which row Insert/update/delete operation is performed but it does not track what exact value is changed. If we want an audit of database means whatever changes occurred …
Although it is a old feature for those who knows ORACLE but for SQL server developers it is a new feature. Let understand it by an example. Suppose we want an auto incremented column a part from primary key which is a identity column, then to achieve this we can use sequence feature. We can …