create procedure myprocedure as begin-- by passing to a variabledeclare x intset x = dbo.function_name()or-- select it directlyselect dbo.function_name()or-- inline queryselect *, dbo,function_name()from table_name end