hi,
i read this artical https://learn.microsoft.com/en-us/sql/relational-databases/user-defined-functions/scalar-udf-inlining?view=sql-server-ver16
but could not reproduce the following results , is ther any query or example on interent where i can see the following in action.
Check whether inlining has happened or not
If all the preconditions are satisfied and SQL Server decides to perform inlining, it transforms the UDF into a relational expression. From the query plan, it's easy to figure out whether inlining has happened or not:
The plan xml won't have a <UserDefinedFunction> xml node for a UDF that has been inlined successfully.
Certain XEvents are emitted.