By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE PROCEDURE myproc
@month int = NULL
AS
BEGIN
SET @month = COALESCE(@month, Month(GetDate()));
SELECT @month;
END;
EXEC myproc;
| (No column name) |
|---|
| 9 |
EXEC myproc 1;
| (No column name) |
|---|
| 1 |