sql create stored procedure
snippet in sql

sql stored procedure

user4351


  CREATE PROCEDURE procedure_name

  AS
sql_statement

  GO; 

sql create stored procedure

user9709

----------------------------------------------------------------------------------------------------
-- MySQL (scroll down for Oracle)

-- example
CREATE OR REPLACE PROCEDURE select_employees()
BEGIN
   select * 
   from employees 
   limit 1000; 
END; -- Reset the delimiter

/* syntax:
CREATE PROCEDURE <Your-procedure-name>(<argument1><argument2>...<argumentN>)
BEGIN
   <Code-that-stored-procedure-executes>; 
END;
*/

----------------------------------------------------------------------------------------------------
-- Oracle

-- EXAMPLE
CREATE OR REPLACE PROCEDURE select_employees()
BEGIN
   select * 
   from employees 
   limit 1000; 
END;

/* SYNTAX
CREATE OR REPLACE PROCEDURE <Your-procedure-name>(<argument1><argument2>...<argumentN>)
BEGIN
   <Code-that-stored-procedure-executes>; -- Remember, the delimiters within the stored procedure remain ;
END;
*/
----------------------------------------------------------------------------------------------------

create proc

user7798

IF OBJECT_ID ( 'Production.uspGetList', 'P' ) IS NOT NULL   
    DROP PROCEDURE Production.uspGetList;  
GO  
CREATE PROCEDURE Production.uspGetList @Product varchar(40)   
    , @MaxPrice money   
    , @ComparePrice money OUTPUT  
    , @ListPrice money OUT  
AS  
    SET NOCOUNT ON;  
    SELECT p.[Name] AS Product, p.ListPrice AS 'List Price'  
    FROM Production.Product AS p  
    JOIN Production.ProductSubcategory AS s   
      ON p.ProductSubcategoryID = s.ProductSubcategoryID  
    WHERE s.[Name] LIKE @Product AND p.ListPrice < @MaxPrice;  
-- Populate the output variable @ListPprice.  
SET @ListPrice = (SELECT MAX(p.ListPrice)  
        FROM Production.Product AS p  
        JOIN  Production.ProductSubcategory AS s   
          ON p.ProductSubcategoryID = s.ProductSubcategoryID  
        WHERE s.[Name] LIKE @Product AND p.ListPrice < @MaxPrice);  
-- Populate the output variable @compareprice.  
SET @ComparePrice = @MaxPrice;  
GO