表值函数可以解决这个问题。
此外，您还可以完全像处理表那样来处理表值函数。
You can also treat the table-valued function just as you would a table.
提供创建使用表值对象（如表值函数和视图）的查询的步骤。
Provides steps for creating queries that use table-valued objects, such as table-valued functions and views.
当您使用表值函数时，需要给它的参数赋值后才能运行查询。
When you use a table-valued function you'll need to assign a value to its parameters before you can run the query.
可以从服务器资源管理器中拖动表、列、视图、同义词或表值函数。
You can drag a table, column, view, synonym, or table-valued function from Server Explorer.
这些特性包括枚举支持、空间数据类型、自动编译LINQ查询、表值函数和多结果存储过程。
These include Enum support, Spatial data types, auto-compiled LINQ queries, Table-Valued functions, and stored procedures with multiple results.
由于拥有可枚举对象，因此我定义表值函数的过程与定义regexmatches函数的过程一样。
Now that I have an enumerable object, I define a table-valued function just as I did with the RegexMatches function.
对于不报告计数器值的任何输出列(例如基于状态的输出)，包装器直接返回底层监控表函数产生的数据，不做修改。
Any output columns that do not report counter values (for example, state based output) are returned directly from the underlying monitoring table function with no modification by the wrapper.
此函数接受两个参数：表的名称以及字段名和值的关联数组。
The function takes two arguments: the name of the table and an associative array of field names and values.
创建返回多个值的表函数也不太困难。
Creating a table function that returns multiple values isn't much more difficult.
Lua中的基本类型(值)有8种：nil，布尔型，数字，字符串，函数，线程，表以及用户数据。
There are eight fundamental types (of values) in Lua: nil, Boolean, number, string, function, thread, table, and userdata.
如果fetch函数返回TRUE，则catalog表中已经定义了这个catalogid值。
If the fetch function returns TRUE, the catalog id value is defined in the catalog table.
GENROW表函数会生成在IN 谓词的 <VALUELIST> 中所列的值。
The GENROW table function produces the values listed in the <VALUE LIST> of the IN predicate.
下面这个例子展示了如何为一个聚合函数max从EMPLOYEE表中检索salary的值
The next example shows how you can retrieve the value for the aggregate function max for the salary column from the EMPLOYEE table
函数可以返回单一值(对于标量函数)或多个值(对于表函数)。
The functions can be coded to return a single value (for scalar functions) or multiple values (for table functions).
元表的键值称为事件；值（换而言之就是函数）称为元方法。
The keys of the metatable are called events; the values (in other words, the functions) are called metamethods.
这个包装器函数的输入值与底层监控表函数相同，所以它也能够筛选返回的数据。
The wrapper function takes as input the same values passed as input to the underlying monitoring table function, so it has the same capability to filter the data that is returned.
这会带来一个新的可调用的函数serialize，该函数获取表单内的所有输入字段并创建这些字段的名称和值的哈希表。
This gives a new function to call, the serialize function, which gets all the input fields in the form and creates a hash of their names and values.
稍后，样式表在函数中生成调用，并再次将值传递给脚本(通过XSLTposition函数)，如清单7中以蓝色突出显示的行所示。
Later the style sheet generates calls into the function and, again, passes a value to the script (through the XSLT position function), as shown in the lines of Listing 7 highlighted in blue.
该函数使用查找表来确定目标列值。
Lookup, a function that USES a lookup table to determine the destination column value.
请注意，在查询10中多获得了一行，这是因为SQL的groupby函数还为null值生成一个组，我们的示例表中有一名员工没有办公室信息。
Note that we get an extra row from Query 10, because SQL's group by also produces a group for NULL values, and there is one employee in our sample table with no office information.
另外，任何lua值——包括函数或其他表——都可以用作字典元素的键值。
Moreover, any Lua value — including a function or another table — can serve as a dictionary element key.
在updatecatalog函数中，获取表单字段值，并创建一条sql语句，以便将一行添加到数据库表Catalog中。
In the updateCatalog function, retrieve the form field values and create an SQL statement to add a row to database table Catalog.
RAND _ LOOKUP，随机查找函数，该函数根据作为查找表中下标的随机数从查找表中选择目标列的值。
RAND_LOOKUP, a random lookup function that selects a value for the destination column from a lookup table based on a random number as the subscript in the lookup table.
values子句还为用户指定的oid列的值包括了一个casting函数，因为该值必须强制转换成目标表的REFERENCE类型。
The VALUES clause also includes a casting function for the user-specified value of the OID column because the value must be cast into the REFERENCE type of the target table.
清单9中的 addProduct() 函数接收一个新产品记录作为键-值对数组，然后使用 Zend_Db对象的insert() 函数将记录写入到数据库表中。
The addProduct() method in Listing 9 accepts a new product record as an array of key-value pairs and then uses the Zend_Db object's insert() method to write this record to the database table.
for子句中的distinct -values函数返回一个列表，其中包含在items表的comments列中的所有Comment中发现的所有不同的productid值。
The distinct-values function in the for clause returns a list of all the distinct values of ProductID that are found inside comments in the comments column of the Items table.
HASH_LOOKUP，该函数根据源列派生的值来确定查找表的目标列值。
HASH_LOOKUP, a function that determines the destination column value from a lookup table according to a value derived from a source column.
如果不提供查找表，该函数将未修改的源值复制到目标中。
If you do not provide a lookup table, the vi copies the source value to the destination unmodified.
如果不提供查找表，该函数将源像素值不修改复制到目标像素。
If you do not provide a lookup table, the vi copies the source value to the destination unmodified.
应用推荐