exec stored procedure with parameters code example
Example 1: sql server execute stored procedure with parameters
CREATE PROCEDURE dbo.uspGetAddress @City nvarchar(30) AS
SELECT * FROM Person.Address WHERE City = @City
EXEC dbo.spGetAddress @City = 'Bordeaux'
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;