Halloween Store: Select 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: