Exportera (0) Skriv ut
Visa allt
EN
Det här innehållet finns inte tillgängligt på ditt språk men här finns den engelska versionen,

CREATE PROCEDURE (Azure SQL Database)

This topic is OBSOLETE. You can find the most current version in the SQL 14 Transact-SQL Reference.

ImportantImportant
This topic is not maintained. For the current version, see CREATE PROCEDURE (Transact-SQL).

Creates a stored procedure.

Syntax Conventions (Azure SQL Database)


CREATE { PROC | PROCEDURE } [schema_name.] procedure_name 
    [ { @parameter [ type_schema_name. ] data_type } 
    [ VARYING ] [ =default ] [ OUT | OUTPUT ] [READONLY]
    ] [ ,...n ] 
[ WITH <procedure_option> [ ,...n ] ]
AS { <sql_statement> [;][ ...n ] }
[;]
<procedure_option> ::= 
    [ RECOMPILE ]
    [ EXECUTE AS Clause ]

<sql_statement> ::= 
{ [ BEGIN ] statements [ END ] }


This syntax diagram demonstrates the supported arguments and options in Microsoft Microsoft Azure SQL Database.

Microsoft Azure SQL Database does not support the following arguments and options with the CREATE PROCEDURE statement:

  • FOR REPLICATION option

  • EXTERNAL NAME ( external methods)

  • ENCRYPTION option

For more information about the arguments and the CREATE PROCEDURE statement, see CREATE PROCEDURE (Transact-SQL) in SQL Server Books Online.

Gruppinnehåll

Lägg till
Visa:
© 2014 Microsoft