Assignment 8 - Assignment 8 Course Material: 1. Read...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Assignment 8 Course Material: 1. Read Chapter 8 Improving Data Access in textbook to get an overview of concepts and terminology. 2. (Resources) View Data Access and Performance Tutorial. This is a PowerPoint presentation. Some additional notes are included with some slides for explanation. Create a Stored Procedure: Follow the steps below to create a stored procedure. Use the database for Chapter 8 in the Project Manual for this part of the assignment. Similar examples can be found on page 180 in Project Manual or page 286 in Textbook. 1. Launch SQL Server and expand the Chapter 8 database. If you have not installed it, you can use the Chapter 7 database for this part. Expand Tables heading. 2. Review the table information for the CustomerEmployee table. Note fields that allow Nulls, Identity columns, default constraints. 3. Run a query to view all the data in the CustomerEmployee table. Note values in CustNum fields. (CustNum is a foreign key in the CustomerEmployee table that references the primary key
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 09/21/2011 for the course CGS 2545 taught by Professor Markllewellyn during the Summer '10 term at University of Central Florida.

Ask a homework question - tutors are online