SQL Scripts

Please make sure you do a "Destroy Merge" after you run a scenario.

Download the following SQL Scripts:

Scenarios

• You have 2 developers that want to make change to the system. Try the following files in the simulator to see what would happen. Remember that order the files are executed in is important.

144B

developer_A.pgsql

90B

developer_B.pgsql

• A developer tries to select more SSN's at one time than the audit table amount allows. How will SQL Simulator react?

27B

select_no_where_clause.pgsql

• A developer submits a SQL that is only supposed to delete 1 record. Try doing a Preview and a Postview merge to see the difference in how SQL Simulator reacts.

215B

delete.pgsql

• A developer submits a update SQL. Try doing a Preview and a Postview merge.

89B

Update.pgsql

• A developer submits an insert SQL. You have a sneaky suspicion that he did not test his code and if you ran this in production you would get a unique key constraint error. Try doing a dry run to see what would happen.

92B

insert.pgsql