sp_execute vs. sp_executesql

  • sp_execute and sp_executesql are not the same thing.

    sp_execute is used with prepared statements by client APIs. (ODBC, ADO.NET etc)

    sp_executesql is used by tsql for dynamic queries.

     

Viewing post 1 (of 2 total)

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