create procedure myprocedure as begin -- by passing to a variable declare x int set x = dbo.function_name() or -- select it directly select dbo.function_name() or -- inline query select *, dbo,function_name() from table_name end