create proc test
(
@parameter int=null
)
as
begin
if(@parameter is null)
select * from tablename
else
select * from tablename where columnname=@parameter
end
exec test
or
exec id (value)No error for parameter @id not passed in stored procedure.
