What are all operations not allowed in user defined functions?

842    Asked by JakeSanderson in SQL Server , Asked on Feb 15, 2020
Answered by Rachit Gupta

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



Your Answer

Interviews

Parent Categories