418 Part I EXAM PREPARATION STEP BY STEP
418 Part I EXAM PREPARATION STEP BY STEP 7.5 Adding Data Through a View 1. Open the Query Analyzer by selecting it from the Start menu. 2. You are going to add data through EmployeeView, which was the view you created in Step by Step 7.4. To avoid adding a row that will conflict with the WHERE clause condition, you need to see the definition of the view. Use sp_helptext to display the definition of the view, as shown in Figure 7.11: Sp_helptext EmployeeView FIGURE 7.11 The definition of EmployeeView. 3. Now, INSERT a record into the base table, making sure the new record does not conflict with the condition specified in the WHERE clause of the view definition: INSERT INTO EmployeeView (emp_id, fname, lname, job_lvl) VALUES ( AEE21349M ,
For high quality website hosting services please check java web hosting website.