The below are the basic differences between Views and UDF's.
1. Views cannot accept parameters where as UDF's can accept parameters.
2. Output of the views cannot be directly used in the Select clause where as UDF's out put can use directly in Select Clause.
1. Views cannot accept parameters where as UDF's can accept parameters.
2. Output of the views cannot be directly used in the Select clause where as UDF's out put can use directly in Select Clause.
Is it possible to call the View in User defined function and vice-versa.
ReplyDelete