如何在sql中创建视图 [英] how to create view in sql

问题描述

先生，

bellow是我在sql中创建视图的示例代码。但是它会生成错误，请帮我修复错误。如果有人知道答案，请帮助我...

CREATE VIEW HR AS SELECT First_Name FROM HR_EMP_MASTER WHERE Emp_Id = @ p_emp_id;

解决方案

语法视图

  CREATE   VIEW  view_name  AS  
  SELECT  column_name（s）
  FROM  table_name 
  WHERE 条件

eck t

您可以检查两个字段Emp_Id = @ p_emp_id是否存在。

创建视图HR

AS

DECLARE @p_emp_id int

SELECT First_Name FROM HR_EMP_MASTER

WHERE Emp_Id = @ p_emp_id





试试这个，你的错误就是r esolved ...

sir,
bellow is my example code for creating view in sql.but its generates error, please help me to fix the error.if any one knows the answer please help me...
CREATE VIEW HR AS SELECT First_Name FROM HR_EMP_MASTER WHERE Emp_Id=@p_emp_id;

解决方案

syntax for craete view

CREATE VIEW view_name AS
SELECT column_name(s)
FROM table_name
WHERE condition

eck t
you can check both field "Emp_Id=@p_emp_id"whether present or not .

CREATE VIEW HR
AS
DECLARE @p_emp_id int
SELECT First_Name FROM HR_EMP_MASTER
WHERE Emp_Id=@p_emp_id


Try this, and your error will be resolved...

这篇关于如何在sql中创建视图的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！