'CREATE/ALTER PROCEDURE' must be the first statement in a query batch.

How to solve this error .
Whenever we create procedure like..
Use [Db_Name]
ALTER procedure [schema].[Procedure_name]
(
@field1 varchar(16)=null
)
Since there is nothing between use[ db name ]and
[ create/alter proc name]  hence  this error come.
just write like this .

Use [Db_Name]
GO
ALTER procedure [schema].[Procedure_name]
(
@field1 varchar(16)=null
)

If you don't want to use go then r

Share This