Halloween Store Version 2: Update and Insert Records

Objectives: 

  • Practice working with databases. In this exercise, you will SELECT and INSERT new records to the database.

Here is our interface:

Save our lab solution: HalloweenCustom.zip

Here is the Table definition and SELECT statement in SQL Server 2008 R2: