It seems like everyone has their own opinion about using stored procedures. And I'm not here to tell you what's right or wrong. I'm just bringing it to your attention because Alpha developer Bob Moore has created new videos showing you how to call a SQL stored procedure with arguments.
Why would you want to call a SQL stored procedure? Because it offers many benefits, such as reduced traffic between an application and the database server; increased app performance; it's reusable, transparent, and secure; and offers code management and access to expert level SQL programmers for distribution of the programming load. However, some developers argue against using stored procedures because it locks you into a SQL vendor.