sql server 2000

来自「JAVA下的SQL_System的建立」· 代码 · 共 41 行

--第十章--创建和使用视图

--创建一个视图，其中仅包括sort，truename，sex，province四个字段：
CREATE VIEW member_view_col
AS
SELECT sort, truename, sex , province 
FROM member

--视图将仅仅显示id>2000的记录
CREATE VIEW member_view_row
AS
SELECT *
FROM member
Where id > 2000

--把company和chanpin表合并成一个虚拟表：
CREATE VIEW chanpin_company_view
AS
SELECT company.manager,chanpin.leibie
FROM company,chanpin
WHERE company.id = chanpin.qiyeid
GROUP BY company.manage,chanpin.leibie

--察看所有用户的计分总额：
CREATE VIEW  sum_jifen_view
AS
SELECT jifen,
SUM(jifen)
FROM member
GROUP BY jifen

--查看数据库表：
SELECT CompanyName, ContactName, Phone, Country
FROM dbo.Customers

--下例删除 titles_view 视图。
USE pubs
IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS
         WHERE TABLE_NAME = 'titles_view')
   DROP VIEW titles_view
GO