T-SQL

This section contains some test scripts for create SQL Database Tables and experimenting with Queries, Triggers, XML and more, Great simple scripts.

For the most part you can just cut and paste these into SMSS

  1. Run the create tables script
  2. Do some queries and mess with CTE’s
  3. Run the Trigger Script (it will create 2 backorder items on Monkey in Products)
  4. Run some XML
  5. Run supplyOrders to play with posting a supply order then filling it and updating the products Table.