SQL Server: how to create a stored procedure

Question

I'm learning sql from a book and I'm trying to write a stored procedure but I don't believe that I'm doing it correctly. Is the following way not valid in Microsoft SQL? If not, when is it valid, if ever?

create procedure dept_count(in dept_name varchar(20), out d_count integer)    begin      select count(*) into d_count      from instructor      where instructor.dept_name=dept_count.dept_name    end 

I get the following error

Msg 156, Level 15, State 1, Procedure wine_change, Line 1 Incorrect syntax near the keyword 'in'.

Answer 1

T-SQL

/*  Stored Procedure GetstudentnameInOutputVariable is modified to collect the email address of the student with the help of the Alert Keyword */    CREATE  PROCEDURE GetstudentnameInOutputVariable (  @studentid INT,                   --Input parameter ,  Studentid of the student @studentname VARCHAR (200) OUT,    -- Output parameter to collect the student name @StudentEmail VARCHAR (200)OUT     -- Output Parameter to collect the student email ) AS BEGIN SELECT @studentname= Firstname+' '+Lastname,      @StudentEmail=email FROM tbl_Students WHERE studentid=@studentid END