Alpha Software is focused on enabling developers to create robust, data-driven business applications that run on any PC, Tablet or Smartphone in the fastest, most efficient and cost-effective manner possible.

Share this blog:

Friday, December 10, 2010

How to call a SQL stored procedure with arguments

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.

If you're interested in learning more about stored procedures, watch Bob's two-part video. Part one covers the client-side JavaScript, the server-side Xbasic, and the T-SQL at the SQL Server. Part two discusses another option for passing arguments from JavaScript to the Xbasic callback function. It also includes a discussion of using Firebug for client-side debugging of Ajax callbacks.

Part one

Part two


Related Posts Plugin for WordPress, Blogger...