You need to ensure that when the UPDATE statement causes an exception, SP1 performs the following tasks: • The INSERT statement is committed, • All data is in a consistent state
You need to ensure that without modifying the SELECT statements, you enable users to query the historical data