Yes, stored procedures through the Gateway are supported for SQL Server data sources, including those that use parameters.