Creating a VIEW in SQL-Server [closed]

Question

Closed. This question needs debugging details. It is not currently accepting answers.

Closed 4 months ago.

I'm trying to create a VIEW in my database, and it shows me

"Incorrent syntax error"

Am I doing something wrong?

CREATE VIEW must be the only statement in the batch. (Which would be the error if you hover your mouse over the red squiggly line) — HoneyBadger
– HoneyBadger, Commented Apr 20, 2020 at 13:06
Please do not post code as images. See here for more details why: meta.stackoverflow.com/questions/285551 — user330315
– user330315, Commented Apr 20, 2020 at 13:22
Does this answer your question? CREATE VIEW must be the only statement in the batch — Ilyes
– Ilyes, Commented Apr 20, 2020 at 13:22

karthik kasubha · Accepted Answer · 2020-04-20 14:17:46Z

2

Include GO between your Create View and Select query (or) view should be the only statement.

CREATE  VIEW  [dbo].[View_name]  As

-- view logic

GO


Select * from table

answered Apr 20, 2020 at 14:12

karthik kasubha

4421 gold badge3 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Pankaj_Dwivedi · Accepted Answer · 2020-04-20 13:20:20Z

2

You selected two select statements. You should run only statement starting from Create View till where clause.

create view view_name as select id from tab where id = some_id;

Just run one statement of create view that's it.

answered Apr 20, 2020 at 13:20

Pankaj_Dwivedi

5804 silver badges15 bronze badges