createprocedure

  • 网络创建存储过程

createprocedurecreateprocedure

createprocedure

创建存储过程

Oracle... ... DROPANYTABLE 在任何模式中删除表 CREATEPROCEDURE 创建存储过程 EXECUTEANYPROCEDURE 执行 …

1
All types of replication allow you to replicate stored procedure definitions: the CREATE PROCEDURE is copied to each Subscriber. 各种类型的复制都允许复制存储过程定义:将CREATEPROCEDURE复制到每个订阅服务器。
2
CREATE PROCEDURE statements cannot be combined with other SQL statements in a single batch. CREATEPROCEDURE语句不能与其他SQL语句在单个批处理中组合使用。
3
To create an autonomous procedure, the keyword AUTONOMOUS is specified on the CREATE PROCEDURE statement, as shown in Listing 2. 要创建自治过程,需要在CREATEPROCEDURE语句中指定关键字AUTONOMOUS,如清单12所示。
4
The result set forms the complete CREATE PROCEDURE statement used to create the custom stored procedure. 该结果集构成了用于创建自定义存储过程的完整CREATEPROCEDURE语句。
5
The result set forms the complete CREATE PROCEDURE statement necessary to create the custom stored procedure. 该结果集构成创建自定义存储过程所需的完整CREATEPROCEDURE语句。
6
If any of the above queries fail to return the desired remote procedure, error SQL1253N is thrown during CREATE PROCEDURE. 如果以上任何查询无法返回所需的远程过程,那么在执行CREATEPROCEDURE期间会抛出错误SQL1253N。
7
To avoid this scenario, use the RETURNS clause of the CREATE PROCEDURE statement to return data to the caller. 要避免这种情况,使用CREATEPROCEDURE语句的RETURNS子句来将数据返回给调用者。
8
Stored Procedures and User-Defined Functions Supports both the CREATE PROCEDURE and CREATE FUNCTION statements. 存储过程和用户定义函数支持CREATEPROCEDURE和CREATEFUNCTION语句。
9
The code changes from CREATE PROCEDURE to ALTER PROCEDURE, and the stored procedure appears in Server Explorer in the Stored Procedure node. 代码将从CREATEPROCEDURE变为ALTERPROCEDURE,并且该存储过程显示在“服务器资源管理器”中的“存储过程”节点下。
10
The CREATE PROCEDURE definition itself can include any number and type of SQL statements, except for the following statements. CREATEPROCEDURE定义自身可以包括任意数量和类型的SQL语句,但以下语句除外。
11
First look at the CREATE PROCEDURE statement to confirm what parameters each of the stored procedures expects. 先看一下CREATEPROCEDURE语句,确定每个存储过程所需要的参数。
12
For more information about deferred name resolution, see CREATE PROCEDURE (Transact-SQL). 有关延迟名称解析的详细信息,请参阅CREATEPROCEDURE(Transact-SQL)。
13
CREATE PROCEDURE statement was not issued to define a procedure at the current server. 没有通过发出CREATEPROCEDURE语句在当前服务器上定义过程。
14
Procedure parameters appear as a list in the CREATE PROCEDURE statement. 过程参数在CREATEPROCEDURE语句中作为列表出现。
15
Generates the CREATE PROCEDURE statement that creates a dynamic update stored procedure. 生成创建动态更新存储过程的CREATEPROCEDURE语句。
16
For information about data type restrictions, see CREATE PROCEDURE (Transact-SQL). 有关数据类型限制的信息,请参阅CREATEPROCEDURE(Transact-SQL)。
17
The CREATE PROCEDURE statement itself contains both the RESULT specification and the compound statement that forms its body. CREATEPROCEDURE语句本身包含RESULT规范以及构成其主体的复合语句。
18
Alternatively, you use the CREATE PROCEDURE statement to create procedures. 此外,可以使用CREATEPROCEDURE语句创建过程。
19
Modifies a previously created procedure that was created by executing the CREATE PROCEDURE statement. 修改先前通过执行CREATEPROCEDURE语句创建的过程。
20
One or more parameters can be declared in a CREATE PROCEDURE statement. 在CREATEPROCEDURE语句中可以声明一个或多个参数。
21
You can assign default values to procedure parameters in the CREATE PROCEDURE statement. 可以在CREATEPROCEDURE语句中将缺省值指派给过程参数。
22
To that end, you should change the CREATE PROCEDURE statement and the C code to allow for additional parameters. 为此,应该更改CREATEPROCEDURE语句和C代码,以允许使用更多的参数。
23
Here are some of the CREATE PROCEDURE implementation differences for the various platforms. 以下是各种平台在CREATEPROCEDURE实现方面的一些差异。
24
The CREATE PROCEDURE statement creates a procedure in the database. CREATEPROCEDURE语句在数据库中创建过程。
25
You can create federated procedures using the CREATE PROCEDURE (Sourced) statement. 可以使用CREATEPROCEDURE(Sourced)语句创建联邦过程。
26
In this example, we have chosen to fix the CREATE PROCEDURE statement instead of modifying the source code. 在这个例子中,我们选择修改CREATEPROCEDURE语句而不是修改源代码。
27
You can issue a remote procedure call using either Sybase Central or the CREATE PROCEDURE statement. 您可以使用SybaseCentral或CREATEPROCEDURE语句发布远程过程调用。
28
If a default value is provided in the CREATE PROCEDURE statement, missing parameters are assigned the default values. 如果在CREATEPROCEDURE语句中提供了缺省值,缺少的参数会被分配缺省值。
29
You can create stored procedures using the CREATE PROCEDURE Transact-SQL statement. 您可以使用Transact-SQL语句CREATEPROCEDURE来创建存储过程。
30
It also shows how to take advantage of the result set syntax in the CREATE PROCEDURE statement. 还演示如何在CREATEPROCEDURE语句中利用结果集语法。