如何编写使用函数的存储过程并将参数发送给函数

I need to write stored proc that gets a value from one table. Calculate new value according the retrieved value and sends the new value to a function.I need to write stored proc that gets a value f