sql run stored procedure code example

Example 1: create select stored procedure in sql server

CREATE PROCEDURE sp_getRaces
AS
BEGIN 
SELECT * FROM dbo.Races
END ;

Example 2: run stored procedure sql

-- Datagrip: 
call MY_SCHEMA.my_procedure();
-- SQL Developer
exec MY_SCHEMA.my_procedure();
-- Shorter than :
BEGIN
	MY_SCHEMA.my_procedure();
END;