ITT Technical Institute‎ > ‎Course Archive‎ > ‎PT2520: Database Concepts‎ > ‎Weeks‎ > ‎10‎ > ‎

Project Load Data


Instructions

Step 10 of the course project references the file ProjectLoadData.sql.  You may either download the file or cut-and-paste the following code into SQL Manager.

SQL Code

EXECUTE usp_RecordPatientVisit '1-24', '8/1/2012', '125/80', 125.8, 45, 5, 'No progress'
EXECUTE usp_RecordPatientVisit '1-24', '8/15/2012', '125/80', 126.7, 45, 4, 'Better'
EXECUTE usp_RecordPatientVisit '1-24', '8/27/2012', '130/70', 125.9, 60, 3, 'Happy'
EXECUTE usp_RecordPatientVisit '1-24', '9/7/2012', '125/70', 124, 48, 6, 'Bad week'
EXECUTE usp_RecordPatientVisit '1-24', '9/18/2012', '124/70', 125.8, 50, 3, 'Much improved'
EXECUTE usp_RecordPatientVisit '2-3', '8/1/2012', '145/80', 148.4, 55, 8, 'Very sad'
EXECUTE usp_RecordPatientVisit '2-3', '8/15/2012', '144/70', 148, 54, 6, 'Better'
EXECUTE RecordPatientSymptoms '1-24', '8/1/2012', 'Restlessness'
EXECUTE RecordPatientSymptoms '1-24', '8/15/2012', 'Restlessness'
EXECUTE RecordPatientSymptoms '2-3', '8/1/2012', 'Nausea'

Downloads