What are all operations not allowed in user defined functions?
Below operations are not allowed in the function:
1. We can create / insert /update/delete/alter/ truncate to a permanent table in a function
2. We can’t execute any user define procedure in the function
3. We can apply for transactions inside a function
4. Exception handling is not possible inside a function
5. We can’t return multiple dataset from the function
6. Table cannot be sent as a parameter inside a function. However we can use function with joining the tables using cross apply