SQL Stored Procedures

1.	SQL Stored Procedures
Answer» SQL procedures are stored in SQL codes, which can be saved for reuse again and again. Syntax: CREATE PROCEDURE procedure_name AS sql_statement GO; To execute a stored procedure, EXEC procedure_name; Example: CREATE PROCEDURE SelectAllCustomers AS SELECT * FROM Customers; GO; The above example creates a stored procedure called ‘SelectAllCustomers’, which selects all the records from the customer table.

Answer»

SQL procedures are stored in SQL codes, which can be saved for reuse again and again.

Syntax:

CREATE PROCEDURE procedure_name AS sql_statement
GO;

To execute a stored procedure,

EXEC procedure_name;

Example:

CREATE PROCEDURE SelectAllCustomers AS SELECT * FROM Customers;
GO;

The above example creates a stored procedure called ‘SelectAllCustomers’, which selects all the records from the customer table.

Discussion