sql server - how to create the stored proc with parameter in sqlserver -

how create stored procedure top 25 students year. proc should take year param , return, student id, sum of marks year

alter  procedure getstudents (   @year int ) begin select student-name tbl_students year=@year  

try 1 -

alter procedure dbo.getstudents        @year int  begin      select top 25             student_name           , student_id           , marks = sum(marks)     dbo.tbl_students      [year] = @year      group              student_name           , student_id      order marks desc  end 

or -

alter procedure dbo.getstudents        @year int     , @count int  begin       select student_name, student_id, marks      (          select                   student_name                , student_id                , marks                , rn = row_number on (order marks desc)           (              select                        student_name                     , student_id                     , marks = sum(marks)              dbo.tbl_students               [year] = @year                group                        student_name                     , student_id          ) t      ) t2     t2.rn <= @count  end