When I try to create a procedure, I get an error message:
SQL80001: Incorrect Syntax:" Create Procedure" must be the only statement in the batch
This is my procedure:
CREATE PROCEDURE [dbo].[USP_UserRoles_Select] ( @Rolename VARCHAR(30) = '' ) AS BEGIN Select ID,Name FROM AspNetRoles WHERE Name like @Rolename +'%' END
What does the error mean and how to fix it?