SQL Server 2019

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

create or alter function dbo.foo()
returns table 
with schemabinding
as
return (
       select 
          x = @@PROCID
);
select * from dbo.foo();


x


942774637


create or alter proc dbo.bar
as
begin
   select 
        x= (@@PROCID)
end;
exec dbo.bar;


x


597577167


create or alter function dbo.baz()
returns varchar(100)
as
begin
    return (@@PROCID)
end;
select dbo.baz()


(No column name)


781597538