Stored procedures are one more powerful object we have at our disposal. They can help us handle many tasks, and improve performance and security.

DROP PROCEDURE IF EXISTS p_customer_all;
GO
CREATE PROCEDURE p_customer_all
-- procedure returns all rows from the customer table
AS BEGIN
SELECT *
FROM customer;
END;