Learning Curve…

Sql Error :- ‘CREATE/ALTER PROCEDURE’ must be the first statement in a query batch.’

Posted on: December 30, 2011

Just add these lines before your SP Statements. :-

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


Exp :-

Use YourDatabaseName

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE …

Advertisements
Tags: ,

5 Responses to "Sql Error :- ‘CREATE/ALTER PROCEDURE’ must be the first statement in a query batch.’"

Still I have the problem….
Incorrect syntax near ‘GO’.
Incorrect syntax near ‘GO’.
‘CREATE/ALTER PROCEDURE’ must be the first statement in a query batch.

Ohh… It worked for me.
Try to find something else in Google.

hey I tried every thing in google, Im using Dotnet to run the scripts and it is not working.If I execute the same script in sqlserver it is working..
Please reply…

I didn’t try with dotnet. yes it is working in sqlserver.

i need with dotnet, as it is working with dotnet but i have to remove the go and other script from above create/alter script

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Author

Learning days (Calendar)

December 2011
M T W T F S S
« Nov   Jan »
 1234
567891011
12131415161718
19202122232425
262728293031  

Knowledge Bank (Archives)

I am on Twitter

Blog Stats

  • 510,129 hits

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 43 other followers

%d bloggers like this: