Post reply

Prepared statements IN SQL Server

  • June 19, 2003 at 9:22 am

    #105769

    How are prepared statements handled in SQL Server if I use RDO? Is it more efficient that direct sql execution? How about network traffic?

  • June 23, 2003 at 12:21 pm

    #462690

    Anything that helps SQL use a previously compiled query plan will help. You can accomplish much the same thing by using sp_executesql and parameterizing the query. If you're just running procs, I'd let SQL handle the plan. I'd also consider upgrading to ADO, RDO getting kinda old!

    Either way, the network traffic should be the same, you've still got to send the proc call with parameters (or the sql statement) to the box, get back x rows.

    Andy

    http://www.sqlservercentral.com/columnists/awarren/

    Andy
    Connect with me on LinkedIn

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply