CREATE PROCEDURE creates a stored procedure. Precautions Function creation also applies to stored procedures. For details, see CREATE FUNCTION. The precision values (if any) of the parameters or return values of
syntaxsql Көшіру CREATE [ OR ALTER ] { PROC | PROCEDURE } [ schema_name.] procedure_name [ { @parameter data_type } [ OUT | OUTPUT ] ] [ ,...n ] AS { [ BEGIN ] sql_statement [;][ ,...n ] [ END ] } [;] ...
Syntax CREATEOR REPLACE PROCEDUREprocedure-name(,INOUTINOUTparameter-namedata-typedefault-clause)option-listSQL-procedure-body data-type built-in-typeanchored-variable-data-typearray-type-namecursor-type-namedistinct-type-namerow-type-name built-in-type SMALLINTINTEGERINTBIGINTDECIMALDECNUMERICNUM(5,...
Syntax CREATEOR REPLACEPROCEDUREprocedure-name(,parameter-declaration)procedure-definitionWRAPPEDobfuscated-statement-text procedure-definition option-list SET OPTION-statementSQL-routine-body parameter-declaration INOUTINOUT parameter-namedata-typedefault-clause data-type built-in-typedistinct-type-namearray-type...
In Oracle, you can create your own procedures.The syntax for a procedure is:CREATE [OR REPLACE] PROCEDURE procedure_name [ (parameter [,parameter]) ]I
SHOWCREATEFUNCTIONSHOWCREATEPROCEDURESHOWCREATETABLESHOWCREATEUSERSPATIAL mysql> 2>.查看CREATE DATABASE命令的帮助信息 mysql>?CREATEDATABASEName:'CREATE DATABASE'Description: Syntax:CREATE{DATABASE|SCHEMA}[IF NOT EXISTS]db_name[create_specification]... ...
--Transact-SQL Stored Procedure Syntax CREATE { PROC | PROCEDURE } [schema_name.] procedure_name [ ; number ] [ { @parameter [ type_schema_name. ] data_type } [ VARYING ] [ = default ] [ OUT | OUTPUT ] [READONLY] ] [ ,...n ] [ WITH <procedure_option> [ ,...n ] ] [...
syntaxsql Copy CREATE [ OR ALTER ] { PROC | PROCEDURE } [schema_name.] procedure_name [ ; number ] [ { @parameter_name [ type_schema_name. ] data_type } [ VARYING ] [ NULL ] [ = default ] [ OUT | OUTPUT | [READONLY] ] [ ,...n ] [ WITH <procedure_option> [ ,......
syntaxsql Kopieren CREATE [ OR ALTER ] { PROC | PROCEDURE } [schema_name.] procedure_name [ ; number ] [ { @parameter_name [ type_schema_name. ] data_type } [ VARYING ] [ NULL ] [ = default ] [ OUT | OUTPUT | [READONLY] ] [ ,...n ] [ WITH <procedure_option> [ ,....
Syntax for CREATE PROCEDURE (SQL - external) CREATE PROCEDUREprocedure-name (,parameter-declaration)option-listSQL-routine-body parameter-declaration: INOUTINOUT parameter-name parameter-type parameter-type: built-in-typeTABLE LIKEtable-nameAS LOCATOR built-in-type: SMALLINTINTEGERINTDECIMALD...