Why is this msg showing? (Msg 111, level 15, state 1, procedure getemployeeinfo, line 27 [batch start line 0] 'CREATE/ALTER PROCEDURE' must be the first statement in a query batch.

Question

1.00/5 (2 votes)

See more:

CREATE PROCEDURE getEmployeeInfo
AS
BEGIN
SELECT Emp_Name,
Designation FROM employee
ORDER BY Emp_Name;
END;

What I have tried:

why is this msg showing in sql sever?after i created table i write above sql query to stored procedure

Posted 14-Oct-23 18:27pm

ruvini lakmali

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

OriginalGriff · Answer 1 · 2023-10-14T19:28:00

Solution 1

Make sure that there is no SQL before the CREATE PROCEDURE statement, or if there is, it must be terminated by a GO statement, and that GO must be on a line by itself with no semicolon.

We can't see how you are executing that SQL code, so we can't do that for you!

Posted 14-Oct-23 19:28pm

OriginalGriff

Dave Kreskowiak · Answer 2 · 2023-10-14T19:38:00

What you posted is incomplete. The error is saying there are a LOT more lines to what you tried to execute than what you posted here. The error is on line 27, but you only posted 7 lines of SQL. Post the rest of what you have that includes this SQL.

I get the feeling you're using SQL Server Management Studio to manually create the database and its objects, but you don't know how it works. What you posted is only a single statement of many statements in the window and you're clicking the little Execute button. That button will execute EVERYTHING in the window, not just what you typed, UNLESS YOU FIRST HIGHLIGHT THE STATEMENT YOU WANT TO EXECUTE. Dragging and selecting only the statement you want to execute then clicking the Execute button will execute only what you highlighted.