如何将SQL写成视图

[xzkyulili]

请教如何将下面语句写成视图，并保存。
SELECT ManHaur_CTBL.LingJianID,zbgs=(case when tingyongbz=0 then SUM(ManHaur_CTBL.LingJianZBGS * ManHaur_CTBL.ZhunBeiRS) else 0 end),
SUM(ManHaur_CTBL.LingJianCZGS * ManHaur_CTBL.CaoZuoRS) AS czgs,
Manhaur_ZTBL.TingYongBZ
FROM ManHaur_CTBL INNER JOIN
Manhaur_ZTBL ON
ManHaur_CTBL.LingJianID = Manhaur_ZTBL.LingJianID
GROUP BY ManHaur_CTBL.LingJianID,Manhaur_ZTBL.TingYongBZ

[davorsuker39]

creat view 视图名字
as
SELECT ManHaur_CTBL.LingJianID,zbgs=(case when tingyongbz=0 then SUM(ManHaur_CTBL.LingJianZBGS * ManHaur_CTBL.ZhunBeiRS) else 0 end),
SUM(ManHaur_CTBL.LingJianCZGS * ManHaur_CTBL.CaoZuoRS) AS czgs,
Manhaur_ZTBL.TingYongBZ
FROM ManHaur_CTBL INNER JOIN
Manhaur_ZTBL ON
ManHaur_CTBL.LingJianID = Manhaur_ZTBL.LingJianID
GROUP BY ManHaur_CTBL.LingJianID,Manhaur_ZTBL.TingYongBZ

[ykily]

正确，接分：）

[iswear428]

create view 视图名字
as
SELECT ManHaur_CTBL.LingJianID,zbgs=(case when tingyongbz=0 then SUM(ManHaur_CTBL.LingJianZBGS * ManHaur_CTBL.ZhunBeiRS) else 0 end),
SUM(ManHaur_CTBL.LingJianCZGS * ManHaur_CTBL.CaoZuoRS) AS czgs,
Manhaur_ZTBL.TingYongBZ
FROM ManHaur_CTBL INNER JOIN
Manhaur_ZTBL ON
ManHaur_CTBL.LingJianID = Manhaur_ZTBL.LingJianID
GROUP BY ManHaur_CTBL.LingJianID,Manhaur_ZTBL.TingYongBZ

[vinsonshen]

CREATE VIEW
创建一个虚拟表，该表以另一种方式表示一个或多个表中的数据。CREATE VIEW 必须是查询批处理中的第一条语句。

语法
CREATE VIEW [ < database_name > .] [ < owner > .] view_name [ ( column [ ,...n ] ) ]
[ WITH < view_attribute > [ ,...n ] ]
AS
select_statement
[ WITH CHECK OPTION ]

[vinsonshen]

示例：
CREATE VIEW categories (category, average_price)
AS
SELECT type, AVG(price)
FROM titles
GROUP BY type
GO

[xuhongying8848]

前面直接加
create view 视图名字
as