Error when creating stored procedure SQL Server 2008 R2

Question

i'am getting error on '{' and 'END'

CREATE PROCEDURE getLogsdata 
{
    @id int
}
AS
BEGIN

END

how to remove this errors

Answer 1

Use parenthesis () instead of curly braces {}, and include some code in your procedure.

create procedure dbo.getLogsdata (@id int) as
  begin;
    set nocount on;

    select *
    from dbo.logs
    where id = @id;
  end;
go