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.

107B

developer_A.tsql

112B

developer_B.tsql

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

40B

select_no_where_clause.tsql

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.

209B

delete.tsql

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

86B

Update.tsql

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

89B

insert.tsql