Exec



EXEC (or EXECUTE) runs one of the built-in System Procedures. Parameters are passed in parentheses; the parentheses can be omitted when there are no parameters. Procedure names are not case-sensitive.

User-defined procedures

User-defined stored procedures are not currently available, see Alter Procedure. EXEC with a name that is not a system procedure fails with "Procedure not found".


round-pushpin Runs a procedure without parameters.
EXEC ShowProcesses

round-pushpin Runs a procedure with a parameter.
EXEC ShowLocks(1)