The use of this stored procedure required only the parameter value and the name of the stored procedure itself to be sent from the client application to the database server.
要使用存储过程,仅需从客户机应用程序向数据库服务器发送参数值和存储过程本身的名称即可。
Before DB2 V8.2.2, some of the information returned via the CLP method of retrieving database configuration information was not returned in this stored procedure.
在DB 2V8.2.2之前,该存储过程中不返回通过检索数据库配置信息的CLP方法所返回的一些信息。
This process of retrieving, parsing, and changing an XML document can also be encapsulated in a stored procedure that runs on the database server.
获取、解析和修改XML文档的过程也可以封装在数据库服务器上运行的存储过程中。
There is a new CONNECT_PROC database configuration parameter that you can set to the name of a stored procedure.
有一个新的CONNECT _ PROC数据库配置参数,可以把它设置为存储过程的名称。
You only need to be aware that the APIs are called implicitly with the authorization of the user who called the stored procedure; usually that's also the user who connected to the database.
您只需知道,这些API是用调用该存储过程的用户的授权隐式地调用的,通常该用户也是连接到数据库的用户。
For database designs that require shredding some or all of the contents of XML data, invocation of this stored procedure can be particularly useful after a bulk load of XML or BLOB data.
对于需要分解XML数据的部分或全部内容的数据库设计,可以在批量装载xml或blob数据之后调用这个存储过程。
This stored procedure enables partial updates of XML documents stored natively in the database.
该存储过程支持对本机存储在数据库中的XML文档进行部分更新。
Now when performing the LOAD FROM CURSOR operation within the stored procedure, DB2 tries to establish the remote connection to database SAMPLE with the authorization ID of the local user.
在存储过程中执行LOADFROM CURSOR操作时,DB2尝试用本地用户的授权ID连接远程数据库SAMPLE。
So if the XQuery was registered in the database server as a stored procedure, the maintenance of that would be done as a part of the database.
所以如果XQuery在数据库服务器中注册为存储过程,其维护将作为数据库的一部分。
DBNAME 'DJ' — This is the name of the Sybase ase database that has the stored procedure.
DBNAME'dj '——拥有存储过程的Sybasease数据库的名称。
Let's also use a stored procedure called Bonus_Increase with the following parameters (these objects are available as part of the sample database).
让我们再将名为Bonus_Increase的存储过程与以下参数(这些对象可以在样例数据库中获得)结合使用。
Expand the folder with the name of your database (in this case "DWESAMP") to have a look on the imported tables and the stored procedure.
展开具有数据库名称的文件夹(在本例中是“DWESAMP”),查看所导入的表及存储过程。
A client application can call on the stored procedure to perform a series of native operations in one trip to the database, rather than involving multiple trips to the database server.
客户端应用程序通过调用存储过程只需要访问数据库一次就可以执行一系列本地操作,而不用多次访问数据库服务器。
Medium: This tracing level captures all of the information included in low-level tracing, plus table names, the database name, and stored procedure stacks.
Medium:此跟踪级别捕捉低级跟踪涉及的所有信息,再加上表名、数据库名和存储过程堆栈。
The process involves a "full build" of the stored procedure, in that the source is required for deploying to the database.
这个过程需要对存储过程进行 “完全构建(full build)”,期间,在部署到数据库时,需要用到源文件。
Remember, the Sybase database name where the stored procedure was located is part of the WebSphere Information Integrator server definition.
记住,存储过程所在的Sybase数据库的名称是DB 2 II服务器定义的一部分。
The original goal of the extended stored procedure cache invalidation model was to begin some early prototyping of the database cache invalidation problem.
扩展存储过程缓存无效化模型的原始目标是,开始对数据库缓存无效化问题进行一些早期的原型化工作。
Defining a stored procedure object for IDS is slightly different from defining a stored procedure object for some of the other IBM database flavors supported by the IBM database Add-ins.
为IDS定义存储过程对象与为ibmDatabaseAdd - ins支持的其他IBM数据库类型定义存储过程对象稍微不同。
Stored procedure is an important database object. To use it appropriately simplifies the development of the application procedure, enhances the performance characteristics of the system.
存储过程是一种重要的数据库对象,恰当地使用存储过程可以简化应用程序的开发,提高系统的运行性能。
In detail, it includes the comparison of simple stored procedure with SQL, stored procedure with parameters, and use stored procedure to update database table.
具体包括用存储过程与用SQL语句的对比、使用带参存储过程以及通过存储过程进行数据库表的更新。
Using stored procedure is definetely one of the best ways to query the database but since the emergence of Entity Framework it is widely used.
使用存储过程,绝对是一个查询数据库的最佳途径,但由于实体框架的出现是广泛使用的。
One of the key topics is backend database migration, specially stored procedure migration.
这其中一个关键部分就是后段数据库的移植,尤其是存储过程移植。
And in this paper the visit of the CMS system query model to database is optimized in the stored procedure.
本文利用了存储过程优化CMS系统中查询模块对数据库的访问。
To solve this problem, this paper proposes an algorithm for attribution reduction based on stored procedure, using the superiority of the database technology.
针对这一问题,本文利用数据库技术处理大数据集问题的优越性,提出了一种基于存储过程的属性约简算法。
By means of the stored procedure to encapsulate database operation, avoiding redundancy encoding so that developing efficiency can be greatly improved.
利用存储过程来封装数据库操作,避免了冗余代码,从而大大提高了开发效率。
In code, making use of stored procedure and minimizing the database opening time to improve performance of the system.
代码尽量使用存储过程和尽量减少数据库连接的打开时间等手段来提高性能。
The first name is the name of the stored procedure created in the database;
第一个名称是在数据库中创建的存储过程的名称;
Finally, the detailed idea and class implementation to backup and restore database as well as the application of stored procedure and cursor in restoring database are given.
详细给出了备份和还原的具体思路和类实现,存储过程和游标在还原中的应用。
The functionality of a stored procedure is dependent on the features offered by your database.
存储过程的功能取决于数据库所提供的功能。
The functionality of a stored procedure is dependent on the features offered by your database.
存储过程的功能取决于数据库所提供的功能。
应用推荐