因为通过DADX文档创建和部署用于sql语句和存储过程的Web服务的能力,这种支持在WebSphereStudiov5.1.2中得到了进一步的增强。
This support has been enhanced further with the ability to create and deploy Web services for SQL statements and stored procedures in WebSphere Studio v5.1.2 using DADX documents.
这一技术可能会被用来执行DROPtable语句,或执行创建新用户帐户并将该用户添加到sysadmin角色的系统存储过程。
This same technique might be used to execute a DROP TABLE statement or to execute a system stored procedure that created a new user account and added that user to the sysadmin role.
为完成这个任务,DataStudio使用创建的SQL定义web服务(单一的sql语句或存储过程)。
To do this, Data Studio USES SQL that you create to define the web service (either a single SQL statement, as we did, or a stored procedure).
由于存储过程是在创建时便在服务器上编译了,因此它比单个sql语句执行得更快。
Because a stored procedure is compiled on the server when it is created, it executes faster than individual SQL statements.
创建用于读取和写入数据的sql语句或存储过程。
Creates the SQL statement or stored procedures used to read and write data.
该向导还可以根据输入到向导中的sql语句在数据库中创建新的存储过程。
The wizard can also create new stored procedures in the database based on SQL statements you enter into the wizard.
存储过程于创建时在服务器上进行编译,所以执行起来比单个SQL语句快。
The stored procedure is compiled on the server when it is created, so it executes faster than individual SQL statements.
“创建新存储过程”-选择此选项使向导根据指定的select语句创建一个新的存储过程(在数据库中)。
Create new stored procedure - SELECT this option to have the wizard create a new stored procedure (in the database) based on the specified SELECT statement.
“创建新存储过程”-选择此选项使向导根据指定的select语句创建一个新的存储过程(在数据库中)。
Create new stored procedure - SELECT this option to have the wizard create a new stored procedure (in the database) based on the specified SELECT statement.
应用推荐