ROLLBACK functionality

Note ROLLBACK functionality
Although the ROLLBACK statement returns the data to its prior state, some functionalities,
such as seed values for identity columns, are not reset.