execute a sp in an sp sql code example

Example 1: execute sp in sql server

proc_name paramValue1, paramValue2

Example 2: execute sp in sql server

EXEC proc_name 'paramValue1','paramValue2'