Chapter 7 WORKING WITH VIEWS 421 1. Open
Chapter 7 WORKING WITH VIEWS 421 1. Open the Query Analyzer by selecting it from the Start menu. 2. You will DELETE data through the view you created in the EmployeeView example. To avoid deleting a row that will conflict with the WHERE clause condition, you need to see the definition of the view by running the following: SP_Helptext EmployeeView 3. Now, DELETE the row you added by running the following code: DELETE EmployeeView WHERE emp_id = AEE21349M 4. To make sure the record was deleted, try to query it using the following code. This process is shown in Figure 7.13. SELECT * FROM EmployeeView WHERE emp_id = AEE21349M You will often want to UPDATE data, rather than DELETE it and
If you looking for unlimited one inclusive web hosting plan please check cheap web hosting website.