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.

139B

developer_A.mysql

90B

developer_B.mysql

• 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.mysql

After doing a postview merge try adding the a where clause: where employee_id = 1

• 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.

183B

delete.mysql

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

73B

Update.mysql

• 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.

76B

insert.mysql