Post reply

sp_executesql question

  • February 27, 2004 at 7:24 am

    #496197

    Please do this! I am really interested as I'm going to get .Net real soon and dynamic sql is one of my favorite topics.

     

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • February 27, 2004 at 8:30 am

    #496219

    Hello Frank,

    We discover something really interesting : On SQL Server 7.0, no matter the way we used ADO.NET, it is always sent to the server as a string. Also, it seem to be less efficient on 7.0 (but I wont elaborate on that since it is not the same machine underneath it).

    On SQL Server 2000 we executed 10000 times the same query on the server and the result is:

    With a string it took 2.5 tenth of second more than with the actual parameter (datetime).

    As you said before, it is negligible.

    Carl

     

     

     

  • February 27, 2004 at 8:38 am

    #496223

    Thanks for the info.

    SQL 2k improved greatly on caching dynamic statement. So no suprise with SQL 7 being less efficient.

     

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Viewing 3 posts - 16 through 17 (of 17 total)

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