sql server数据库中的存储过程和表值函数哪个具有最佳性能? [英] Which has best performance that Stored procedure and table valued function in sql server database ?

问题描述

亲爱的任何人，

我使用表值函数从sql server中提取crodes记录.
我需要在许多存储过程中使用此表值函数.
可以告诉我哪种存储系统或表值函数的性能最佳.
如何找到表值函数的成本.


谢谢.
Ganu Sharma

Dear anybody,

i using a table valued function for extracting crodes record from sql server.
i need to use this table valued function in many stored procedure.
can tell me which has best performance stored procedure or table valued function.
how i can find cost of table valued function.


Thanks.
Ganu Sharma

推荐答案

Should I use a view, a stored procedure, or a user-defined function?[^] should be a useful item for you to go through.

这篇关于sql server数据库中的存储过程和表值函数哪个具有最佳性能?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！