EXEC Keyword

The Exec keyword is used to execute a stored procedure.

When you want to run any stored procedure, the execute keyword is used.

Syntax

SQL
EXEC <PROCEDURE_NAME>;

Example

SQL
EXEC GetAllMaleEmployee;

Execute a parameterized stored procedure

Syntax

SQL
EXEC <PROCEDURE_NAME> <PARAM1>,<PARAM2>..<PARAMN>;

Example

SQL
EXEC GetEmployeeFromGender 'Female';

Summary

The Exec keyword is used to execute a stored procedure.