SQL Server: How to execute UPDATE from within recursive function? -

I have a recursive scalar function, which needs to be updated in one of the other tables, depending on the value of the recordings. However, the update details are not allowed in the function.

How can I update the table from within the function? The UPDATE statement is not allowed in the

function

This is the rule - functions are not allowed to change data-changing side-effects.

You have to use the stored procedure on UPDATE .