Ado. NET Review Summary (7)-View

View
(1) Function: Encapsulates a complex SELECT statement to make it easier to use
(2) Syntax:
Create/alter View Name
As
Select ...
Delete: Drop view name
(3) Use: The view name can be used as a table name for various query operations
(4) Suggestions: Do not add, modify, delete through the view, the main query operation

Example:

1. Create a view:

-- Create a View Create View Student_class--alterasselect studentinfo. *  from Studentinfo Inner Join  on Studentinfo.cid=classinfo.cid

View Code

2. Use:

-- The view stores the SELECT statement, not the result set data Select *  from Student_class where Isdelete=0 and Ctitle=' white tiger '

View Code

3. Delete:

-- Delete Drop View Student_class

View Code

Ado. NET Review Summary (7)-View