stored procedure named paramters code example

Example: exec stored procedure with named parameters

declare
    @date varchar(25) = convert(varchar(25), @date, 131);

exec MySP3 @name = 'binesh', @amount = @amt, @date = @date;