With such plumbs, you can target the statement, loop, function, class, or library that is most sluggish.
有了这种垂直度,就可以将语句、循环、函数、类或者是运行缓慢的库作为分析目标。
You can either call the function directly, or create a view based on this statement and then query the view.
可以直接调用此函数,也可以根据这个语句创建视图,然后查询视图。
Also, to explore and test the new update capabilities initially, you may find it convenient to embed the XMLQUERY function with the transform in a SELECT statement rather than an update.
另外,在研究和测试新的更新功能时,在select语句(而不是update语句)中嵌入包含转换表达式的XMLQUERY函数可能更方便。
Row identifier (RID_BIT or RID) built-in function: This built-in function can be used in the SELECT list or predicates statement.
行标识符(RID_BIT或RID)内置函数:该内置函数可用于SELECT列表或谓词语句。
Just like any other built-in function, table functions can be used in a SQL SELECT statement.
就像其他的内建函数一样,表函数也可以在SQLselect语句中使用。
Note that an assignment statement which is assigning a function literal or object literal is still an assignment statement and must end with a semicolon.
注意一个函数赋值或对象赋值语句也是赋值语句,应该以分号结尾。
The XMLVALIDATE function in the action part of trigger statement validates the employee information specified in the INFO column.
触发器语句的操作部分的XMLVALIDATE函数验证在INFO列中指定的雇员信息。
The action part of the trigger statement includes the XMLVALIDATE function to validate the XML documents against the XML schema specified.
触发器语句的操作部分包含xmlvalidate函数,它根据指定的模式验证XML文档。
That implies that the function is called multiple times during the execution of the SQL statement.
这意味着在sql语句的执行期间,该函数会被多次调用。
This automatic validation is done in the action part of the trigger statement using the XMLVALIDATE function.
自动验证是由触发器语句的操作部分通过XMLVALIDATE函数完成的。
The function of AIO is to perform disk I/O when SQL statement accessing or updating database data.
AIO的功能是在SQL语句访问或更新数据库数据时,执行磁盘I/O。
DB2 V8.2.2 introduces a new method that you can use to implement that same change password function in the CONNECT statement.
DB 2V8.2.2引入了一种新的方法,可用于实现connect语句中这一相同的更改密码功能。
After it is converted, the SQL statement is run, and the results are returned from the function.
转换后,将运行sql语句,并且从函数返回结果。
The CREATE transform statement enables an existing function to be used as a transform function.
CREATETRANSFORM允许将现有的函数用作转换函数。
If you want to reissue the same statement multiple times, the odbc_exec function is an expensive approach because it prepares and executes the statement every time.
如果您想多次重复发出同一条语句,那么odbc_exec函数是一种代价高昂的方法,因为它每次都要编译并执行该语句。
If you want to issue the same statement multiple times, the odbc_exec function is an expensive approach because it prepares and executes the statement every time.
如果需要多次发出同一语句,odbc_exec函数是一种代价高昂的方法,因为它每次都要准备和执行这条语句。
The odbc_prepare function prepares an SQL statement with the database management system, then odbc_execute sends in the variables.
odbc _ prepare函数为数据库管理系统准备了一个sql语句,然后odbc_execute函数会在变量中发送该语句。
When you call the odbc_exec function for a SELECT statement, the function returns a result set identifier.
当您为select语句调用odbc_exec函数时,该函数返回一个结果集标识符。
To show SQL statements in PHP, use the echo function for each statement.
要在PHP中显示sql语句,需要对每条语句使用echo函数。
The first line of the query issues a SQL SELECT statement that invokes an industry-standard SQL function (XMLQUERY).
查询的第一行发出一个SQLselect语句,其中调用了一个行业标准的SQL函数(XMLQUERY)。
For several versions, we have had generators defined with the yield statement in a function body.
有几个版本中已出现了在函数体中用yield语句定义的生成器。
You'll have to retrain your fingers to stop typing print "hello" and start typing print("hello"), because print is now a function, not a statement.
如今,您将需要让手指习惯于键入print("hello"),而不是原来的 print "hello",这是因为 print现在是一个函数,不再是一个语句。
When an error occurs or when you want to return a fault to the user, set the WS_FAULT object and exit the method with an Exit function or Exit sub statement.
当错误发生时,或者在您希望向用户返回一个故障时,设置 WS_FAULT对象,并使用一个Exit函数或 Exit子语句退出方法。
The module demonstrates how to prepare an INSERT statement that contains parameter markers using the odbc_prepare() function.
该模块演示了如何使用 odbc_prepare()函数准备包含参数标志的INSERT语句。
Alter the generated SQL statement to include a PASSING clause in the XQuery function.
更改生成的sql语句以在XQuery函数中包括一个passing子句。
The procedure in Listing 22 demonstrates the solidDB scalar function TIMESTAMPDIFF, used in an assignment statement.
清单22中的过程演示了solidDB标量函数TIMESTAMPDIFF,用于一条复制语句。
The obsolete ALTER statement provides the same function as EVALUATE.
已被废弃的alter语句提供了与EVALUATE相同的功能。
On to the answers. You do not need to provide the return type of a lambda function; it is deduced from the return statement.
不需要为lambda函数提供返回类型;根据返回语句推导出返回类型。
TBSCAN(18) represents the RETURN statement in the SQL Table function.
TBSCAN(18)表示这个SQL表函数中的RETURN语句。
Update 2 is an SQL SELECT statement with the same XMLQUERY function, transform expression, and WHERE clause, as in Update 1.
更新2是一个SQLselect语句,其中包含与更新1相同的XMLQUERY函数、转换表达式和where子句。
应用推荐