--Create Procedure--
if object_id('inputtest') is not null
drop proc inputtest
Go
create proc inputtest
--This is proc declare, NOT variable declare--
@input_Student_number int
As
select *
from students
where student_number=@input_Student_number
--Create Procedure--
--Input Variables--
declare @input_new_Student_number int
SET @input_new_Student_number=50005764
exec inputtest
@input_new_Student_number
---------------------------------------------------------------------
Tips:
You don’t need to declare 'Input' type because the default variable type is 'Input'.