您可以建立会传回资料表的使用者定义函式,传回的资料表将包含资料列,其中列出在特定职等管理人员的组织结构中的员工。
You can create a user-defined function that returns a table containing one row for each employee working within a particular high-level manager's organizational hierarchy.
预存程序和使用者定义函式,是SQL陈述式和选择性流量控制陈述式的集合,由资料库伺服器储存为某个名称,并视为一个单位进行处理。
Stored procedures and user-defined functions are collections of SQL statements and optional control-of-flow statements stored under a name and processed by the database server as a unit.
可以是资料库伺服器所定义的函式,或传回纯量值的使用者定义函式。
The function can be a function defined by the database server or a user-defined function that returns a scalar value.
如需详细资讯,以及预存程序和使用者定义函式的范例,请参阅您的资料库伺服器文件。
For more information and examples of stored procedures and user-defined functions, see the documentation for your database server.
您可以在预存程序及使用者定义函式中,执行已选取的文字。
You can run selected text in stored procedures and user-defined functions.
您可以在预存程序及使用者定义函式中,执行已选取的文字。
You can run selected text in stored procedures and user-defined functions.
应用推荐