table column is
studentid sname firstname lastname emailid
i have created a procedure
create procedure getstudentname
(
@studentid int,
@studentname VARCHAR(200) OUT
)
AS
BEGIN
SELECT @studentname= Firstname+' '+Lastname FROM student_demo WHERE studentid=@studentid
END
now how can i call this procedure in sql