SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create procedure foo @bar integer as
select 'A' baz;
exec foo;
Msg 201 Level 16 State 4 Line 0
Procedure or function 'foo' expects parameter '@bar', which was not supplied.

exec foo @bar = 1;


baz


A