exec procedure with parameters code example
Example 1: create select stored procedure in sql server
CREATE PROCEDURE sp_getRaces
AS
BEGIN
SELECT * FROM dbo.Races
END ;
Example 2: exec stored procedure with named parameters
declare
@date varchar(25) = convert(varchar(25), @date, 131);
exec MySP3 @name = 'binesh', @amount = @amt, @date = @date;