t-sql execute sp in sp 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'
proc_name paramValue1, paramValue2
EXEC proc_name 'paramValue1','paramValue2'