question

If multiple functions are used in the code, then logically which will perform first and which next. If we use two UDF's Generally Can you tell me Which UDF's are Perform first? Sample: UDF1: CREATE FUNCTION dbo.UDF1( @Parameter1 INT ) RETURNS Table AS RETURN ( SELECT * from dbo.Table1 A join dbo.Table2 B on A.id= b.id join dbo.Table3 c on A.id= C.id Where A.id=@Parameter1 ) END UDF2: CREATE FUNCTION dbo.UDF2( @Parameter2 INT ) RETURNS INT AS BEGIN RETURN ( SELECT Count(*) from dbo.UDF1(@Parameter2) ) END Result: Declare @Parameter2 int set @Parameter2=5 SELECT dbo.UDF2(@Parameter2) as UDFexecution if we execute UDF2 Can you tell me which UDF execute first?