how to create view in sql

Question

0.00/5 (No votes)

See more:

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;

Posted 6-Dec-13 22:10pm

vineethnair

Add a Solution

Comments

OriginalGriff 7-Dec-13 4:20am

What error does it generate?

[no name] 7-Dec-13 5:05am

What is the error..??

RAHUL(10217975) 7-Dec-13 5:37am

Error Might be @p_emp_id not declare ...:D

Amir Mahfoozi 8-Dec-13 0:53am

Please read here : http://stackoverflow.com/questions/1687279/can-we-pass-parameter-to-a-view-in-sql

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

baliram bhande · Answer 1 · 2013-12-07T03:18:00

Solution 2

syntax for craete view

SQL

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 .

Posted 7-Dec-13 3:18am

baliram bhande

Jain Nishant · Answer 2 · 2013-12-09T19:20:00

Solution 3

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...

Posted 9-Dec-13 19:20pm

Jain Nishant

how to create view in sql

2 solutions

Solution 2

Solution 3

Add your solution here

Preview 0

how to create view in sql

2 solutions

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us