Chapter 7 WORKING WITH VIEWS 423 1. Open
Chapter 7 WORKING WITH VIEWS 423 1. Open the Query Analyzer by selecting it from the Start menu. REVIEW BREAK 2. INSERT a record into the view: INSERT INTO EmployeeView (emp_id, fname, lname, job_lvl) VALUES ( ARP21349M , Frandos , Fung , 10) 3. Assume that you mistook Frandos s last name with another name. To UPDATE the lname column on this record to his real last name, Thatch, run the following query: UPDATE EmployeeView SET lname = Thatch WHERE emp_id = ARP21349M 4. To see the updated record, run the following code. This process is shown in Figure 7.14. SELECT * FROM EmployeeView WHERE emp_id = ARP21349M With this discussion of the UPDATE statement, you have now examined all the different options for data modifications: Inserts,
For high quality jboss hosting services please check jboss web hosting website.