对于每一组具有相同数量和维次序的聚合的度量,需要用单独的选择语句来正确地计算。
A separate select statement will be needed to properly calculate each set of measures that share the same number and dimensional order of aggregations.
因此,您可以计算多个数量,并轻松地将多个结果返回给调用语句。
Therefore, you can compute multiple quantities and easily return them to the calling statement.
仅当when子句的计算结果为真时,触发器语句的操作部分才会执行。
Only if the WHEN clause evaluates to true will the action part of trigger statement be executed.
单件为我们提供了一种可以将 SQL语句中每一个UDF 进行聚集计算时需要的数据存储在另外的对象当中的方式。
The singleton provides us with the means to store another object that is used for the aggregation done in each UDF in the SQL statement.
然而,每个语句的访问计划基本相同,重复的计算是一种资源浪费。
However, the access plan for all the statements was likely the same, so it was a waste of resources to repeatedly calculate it.
数据库服务器自动发出UPDATESTATISTICS语句,为引用该表的所有SPL例程重新计算例程统计信息。
The database server automatically issues the UPDATE statistics statement to recalculate routine statistics for all SPL routines that reference the table.
Wolfram | Alpha的宗旨是允许用户输入人性化的表达语句,并基于此进行计算。
The aim is to allow users to type human-like statements and have computations done on those.
需要在从xpath语句返回的呈现文本中执行字距检查;否则,诸如之类的各个标记将影响距离计算。
Word distance checks need to take place in the rendered text as returned from the XPath statement; otherwise, various markup, such as, will affect the distance calculations.
与SHIP1操作符相关的语句表明该标量子查询在Oracle上计算。
The statement associated with the SHIP1 operator shows the scalar subquery being computed on Oracle.
注意:上面计算的所有货品的总价可以使用let语句分配给一个变量。
Note: the sum of all the items that was calculated above could have been allocated to a variable using a let statement.
因此,当使用sql语句缓存作为输入时,应该在当天的不同时间点运行Design Advisor,以计算更大范围的sql语句。
Therefore, when using the SQL statement cache as input, you should run the Design Advisor at different points throughout the day to evaluate a broader range of statements.
while循环与if语句一样,支持一个可选的else子句,其中包含一个当表达式计算为False时执行的程序语句块。
The while loop, as was the case with the if statement, supports an optional else clause containing a block of program statements executed when the expression is False.
包含sql语句的输入文件有一个代替办法,即让Design Advisor计算数据库的sql语句缓存的内容。
As an alternative to an input file containing SQL statements, you can also have Design Advisor evaluate the contents of the database's SQL statement cache.
可以存在参数标记,因为Design Advisor并没有实际执行sql语句,它仅为它们计算其他可行的访问计划。
Parameter markers are allowed because the Design Advisor does not actually execute the statements, it only evaluates alternative access plans for them.
这两个代码块都会使用switch语句计算int值,从而得到输出到控制台的供人阅读的字符串值。
Both blocks of code evaluate an int value using a switch statement that results in a human-readable string value printed to the console.
因此,查询处理仅限于新模式文档实例,因为旧模式的所有实例计算where语句的结果都是false。
Hence, the query processing is limited to the document instances from the new schema, because all instances from previous schema evaluate the where statement as false.
为了说明这一点,他在他哦个一台计算机上连续运行了很多次相同的代码段,结果运行时都是4.9秒,但当他删除了打印结果的println语句之后,运行时间则缩短到0.08秒。
To illustrate this point, one of his code snippets consistently runs in 4.9 seconds on his computer, but if he omits a println that displays the result, it consistently runs in 0.08 seconds.
记住,您只在表达式为True时执行if语句体。该表达式在当变量i不能被25整除时计算为True。
Remember that you execute the body of an if statement only if the expression is True, which for this expression happens when the variable I is not evenly divisible by 25.
但是,计算机算法与人解读新闻资讯的方式并不相同,它们不需要以叙事的形式、甚至可以不通过语句的形式来传递信息。
They don’t need their information delivered in the form of a storyor even in sentences.
但是第二个if语句计算为True,因为变量i能被125整除(并且not运算符将结果0转换成布尔值True)。
But now the second if statement evaluates True because the variable I is evenly divisible by 125 (and the not operator turns the resulting 0 into a Boolean True).
如果你选择继续运行脚本,就会重新计算当前执行的语句数,也就是说,如果这个数值再次达到上限时,你会再次看到这个对话框。
If you choose to continue running the script, then the executed statement count is reset. You will see the dialog again if the number of statements once again reaches the maximum.
如果多个度量将它们的聚合函数应用于同样的维,而且次序相同,那么可以在同一个语句中计算这些度量。
If the multiple measures apply their aggregation functions on the same dimensions and in the same order as each other, the measures can all be calculated in the same statement.
下面的步骤将创建这些变量并为其赋值,还将添加日志记录语句,以便了解在计算机运行时发生的情况。
The next steps will create and assign values to those variables along with a logging statement so you can see what is occurring as the machine runs.
但是请注意前面这个语句,我用这个语句计算了浮动值。
But notice the previous line, where I am computing volatility.
计算机语言专栏作家在写作英语句子时怎样避免误导读者的一些技巧。
Some tips from the Monitor's language columnist on how to avoid writing sentences that send readers off in the wrong direction.
因为Python需要缩进以错开当表达式计算为True或False时应该执行的语句块,所以两个print语句都缩进了4个空格。
Because Python requires indentation to offset the block of statements that should be executed if the expression evaluates True or False, the two print statements are both indented four Spaces.
计算行的总数就是在len (s)语句中返回的清单元素的数量。
Counting the total number of lines is simply the number of elements in the list returned with the len (s) statement.
if语句支持一个可选的else子句,指示当布尔表达式计算为False时应该处理的程序语句块。
The if statement supports an optional else clause that indicates a block of program statements that should be processed if the Boolean expression evaluates False.
Python中的第二种流控制语句是while循环,它在一个表达式计算为True时执行一个程序语句块。
The second type of flow control statement in Python is the while loop, which executes a block of program statements while an expression evaluates True.
这个计算器利用local语句将x声明为局部变量,只能在mycalc函数的范围内使用。
The calculator makes use of the local statement to declare x as a local variable that is available only within the scope of the mycalc function.
应用推荐