# SQL Scripts

{% hint style="warning" %}
Please make sure you do a "Destroy Merge" after you run a scenario.
{% endhint %}

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.

{% file src="/files/fGgSKtQiyMumQJWQckDY" %}

{% file src="/files/0abFzhcqgcA75RMASzRX" %}

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

{% file src="/files/Y8K2zMKcvghrSphNKjK2" %}
After doing a postview merge try adding the a where clause:  where employee\_id = 1
{% endfile %}

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

{% file src="/files/n3n9Ik5KWlkJqjxBOTib" %}

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

{% file src="/files/fRBlPLzlX99dVnD5pcKY" %}

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

{% file src="/files/qy2PxnShNhgoJmdXG2a0" %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://sql-simulator.tribalknowledge.tech/hello-world-tutorials/sql-server/sql-scripts.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.