Bugl — Daily coding puzzles and drills

CREATE PROCEDURE Keyword

Create Procedure

The CREATE PROCEDURE

command is used to create a stored procedure. A stored procedure is a prepared SQL code that you can save, so the code can be reused over and over again. The following SQL creates a stored procedure named "SelectAllCustomers" that selects all records from the "Customers" table:

Example

CREATE PROCEDURE SelectAllCustomers

AS

SELECT * FROM Customers
GO;

Execute the stored procedure above as follows:

Example

EXEC SelectAllCustomers;

SQL CREATE PROCEDURE Keyword

SQL CREATE PROCEDURE Keyword

CREATE PROCEDURE Keyword

Previous

Next

Create Procedure

The CREATE PROCEDURE

Example

CREATE PROCEDURE SelectAllCustomers

Example

Previous

Next

SQL CREATE PROCEDURE Keyword

SQL CREATE PROCEDURE Keyword

CREATE PROCEDURE Keyword

Previous

Next

Create Procedure

The CREATE PROCEDURE

Example

CREATE PROCEDURE SelectAllCustomers

Example

Previous

Next