This article is a mirror article of machine translation, please click here to jump to the original article.

Architect_Programmer_Code Agriculture Network»Architect › Database & Database › Microsoft SQL Server › sql creates stored procedures with parameters
View: 12273|Reply: 0

[Source] sql creates stored procedures with parameters

[Copy link]
Posted on 10/9/2014 10:47:49 AM | | |
Define the syntax for stored procedures
CREATE PROC[EDURE] stored procedure name
              @参数1 Data type = default,
               …… ,
              @参数n Data type OUTPUT
            AS
            SQL statements
    GO
      As with C functions, the parameters are optional
      Parameters are divided into input parameters and output parameters
      Input parameters allow for default values





Previous:Let's talk about the role of SQL triggers and when they are used
Next:SQL How to query a table to remove duplicates

Related Posts
Disclaimer:
All software, programming materials or articles published by Code Farmer Network are only for learning and research purposes; The above content shall not be used for commercial or illegal purposes, otherwise, users shall bear all consequences. The information on this site comes from the Internet, and copyright disputes have nothing to do with this site. You must completely delete the above content from your computer within 24 hours of downloading. If you like the program, please support genuine software, purchase registration, and get better genuine services. If there is any infringement, please contact us by email.
Mail To:help@itsvse.com