sp execute sql code example

Example 1: execute sp in sql server

proc_name paramValue1, paramValue2

Example 2: execute sp in sql server

exec procName 
    @parameter_1_Name = 'parameter_1_Value', 
    @parameter_2_name = 'parameter_2_value',
    @parameter_z_name = 'parameter_z_value'