Create procedure spSearch
@id int = 1 //input parameter
as
begin
select * from customer where id=@id
end
Execution : exec spSearch 1 or you can execute it as : exec spSearch
Note: In the above code snippet 1 is the default value for id.