片语

Benefits of Stored Procedure预储程序的优点

Stored d Procedure存储过程

System Stored Procedure系统存储过程

Stored Procedure Builder工具

Managed Stored Procedure存储过程

Stored Procedure Design Datasheet存储过程设计数据表

What is Stored Procedure什么是预储程序

Database Stored Procedure数据库存储过程

英汉例句

• when the third stored procedure fails, it triggers an event telling the compensation framework to reverse everything included in this compensation scope.

  第三个存储过程失败时，它会触发一个事件，告诉补偿框架反转此补偿范围中包含的一切。

• this is necessary to use the stored procedure like a table in the report tooling.

  要想像报告处理中的一个表那样使用此存储过程，这非常必要。

• to separate the business logic in the database from the application code, it is a good idea to create a stored procedure for this query.

  为了将数据库中的业务逻辑与应用程序代码隔离开，一种好方法是为这个查询创建一个存储过程。

• using a stored procedure as query subject input has the advantage that no unnecessary tables or views are created in the database.

  使用存储过程作为查询主题输入有一个好处，那就是不需要在数据库中创建不必要的表或视图。

• but first you should create your stored procedure in the destination database mysample.

  但是，首先应该在目标数据库mysample 中创建存储过程。

• the user can choose to modify these fields for the stored procedure being deployed using binaries.

  用户可以选择为使用二进制文件部署的存储过程修改这些字段。

• to enable dynamic invocation, you should create a stored procedure that takes two parameters and invokes the mining flow with this user input.

  为了实现动态调用，需要创建一个存储过程，它接受这两个参数并通过此用户输入调用挖掘流。

• however, they can be resolved if you embed the insert statements above in an sql stored procedure with a little extra logic.

  但是，如果将上述insert语句嵌入到一个包含一点额外逻辑的sql存储过程中，就可以解决这个问题。

• to reduce the impact of logging, you can create a stored procedure and commit the insert in stages.

  为了减少日志记录的影响，您可以创建一个存储过程，并分步提交插入数据。

• identify logging statements for each stored procedure and each db2 agent.

  为每个存储过程和每个db2代理确定日志语句。

• this is useful if you plan to drop the stored procedure and not create it again.

  如果您打算删除存储过程并且不会重新创建它，那么这个操作就有用了。

• parallel invocations of the stored procedure are only allowed if the index name parameters are different.

  只有在索引名称参数不同的情况下，才允许并行调用这个存储过程。

• through this parameter, you can turn off the logging by all the stored procedure at run time.

  利用这个参数，可以在运行时关闭所有存储过程的日志。

• the purpose of this stored procedure is to automate the batch file execution,.

  这个存储过程的目的是自动化批文件的执行。

• we can also see the result set of the stored procedure by selecting from the nickname.

  我们也可以通过从昵称中进行选择来查看存储过程的结果集。

• notice that once the stored procedure returns successfully it registers with the compensation framework.

  注意，一旦存储过程成功返回，它就会使用补偿框架注册。

• what if you could pass the entire file to a stored procedure and let the stored procedure handle the entire process?

  如果您可以将整个文件传递到存储过程并且让存储过程处理整个过程，情况会怎样？

• this is not only faster because of the reduced bandwidth usage, but also faster because the stored procedure can be precompiled.

  其优点不仅仅是降低了带宽的使用，还带来了更快的速度，这是因为存储过程可预编译。

• for this example, you will write a stored procedure that retrieves the names and primary email addresses of clients with a certain status, just as you did earlier.

  对于本例来说，您将编写一个存储过程来检索具有特定状态的客户的姓名和主电子邮件地址，就像前面所做的一样。