Halloween Store: Insert, Update, and Delete Records

Objectives: 

  • Practice working with databases. In this exercise, you will INSERT and UPDATE and DELETE records from the database.

Here is our interface:

Save our lab solution: DowJonesBrowser.rar

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