Multi-Statement Table Valued Functions||SQL||MasterTechClases

returns table
as

select * from fn_getdatabydid(1)

returns @mytable table(Ename varchar(20),Ecity varchar(20))
as
begin
insert into @mytable
return
end

select * from fn_getdatabydidtwo(1)