CREATE VIEW NewMoon_employee AS
SELECT emp_id, fname, minit, lname,hire_date
FROM employee e, publishers p
WHERE e.pub_id = p.pub_id
AND pub_name = 'New Moon Books'
删除视图
drop view 视图名 作者: 张云静 时间: 2012-4-8 17:41
视图的创建:create view 视图名 as 查询语句
删除视图:drop view 视图名
创建视图的例子:
CREATE VIEW view_stuInfo_stuMarks /*创建视图*/
AS
SELECT 姓名=stuName,学号=stuInfo.stuNo,
笔试成绩 =writtenExam, 机试成绩=labExam,
平均分=(writtenExam+labExam)/2
FROM stuInfo LEFT JOIN stuMarks
ON stuInfo.stuNo=stuMarks.stuNo
GO
删除视图的例子:
IF EXISTS (SELECT * FROM sysobjects WHERE name = 'view_stuInfo_stuMarks') /*检测是否存在*/
DROP VIEW view_stuInfo_stuMarks /*删除视图*/
GO 作者: pray 时间: 2014-4-26 06:02
LZ先生您好,您寄来的充气娃娃我们已经给您修好了,马上给您寄回去,但请您以后别那么残暴地对待她,她毕竟只是个娃娃,当她被寄来时,所有在场的工作人员都哭了