BuslerLABGettingStarted -...

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

View Full Document Right Arrow Icon
IST 210 Lab # Getting Started Chelsea Busler 5/28/2011 9. SELECT * FROM [ist210-wc] . dbo . uc_faculty f_id f_last f_first f_mi loc_id f_phone f_rank f_pin --------------------------------------- ------------------------------ ------------------------------ ---- --------------------------------------- ---------- -------- --------------------------------------- 1 Cox Kim J 9 7155551234 ASSO 1181 2 Blanchard John R 10 7155559087 FULL 1075 3 Williams Jerry F 12 7155555412 ASST 8531 4 Sheng Laura M 11 7155556409 INST 1690 5 Brown Philip E 13 7155556082 ASSO 9899 (5 row(s) affected) 13. SELECT s_id , s_last , s_phone FROM [ist210-wc] . dbo . uc_student s_id s_last
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: s_phone--------------------------------------- ------------------------------ ----------1 Miller 2075559876 2 Umato 2075552345 3 Black 2075553907 4 Mobley 2075556902 5 Sanchez 2075558899 6 Connoly 2075554944 (6 row(s) affected) 14. SELECT * FROM [ist210-wc] . dbo . uc_course course_id call_id course_name credits--------------------------------------- ---------- ------------------------- ---------------------------------------1 MIS 101 Intro. to Info. Systems 3 2 MIS 301 Systems Analysis 3 3 MIS 441 Database Management 3 4 CS 155 Programming in C++ 3 5 MIS 451 Web-Based Systems 3 (5 row(s) affected)...
View Full Document

This note was uploaded on 07/13/2011 for the course IST 210 taught by Professor Mcconn,charlotteryoo,jungwoo during the Summer '08 term at Pennsylvania State University, University Park.

Ask a homework question - tutors are online