sp_prepare statement

From: Mario (mcsjr_at_ig.com.br)
Date: 12/29/04

  • Next message: Guy Gervais: "Re: Sql or Oracle" 
    Date: Wed, 29 Dec 2004 08:31:28 -0200

    I have an application built in Delphi, that makes a connection to SQL Server
    2000 using ADO. In the SQL Server Profiler, the querys apear to be executed
    with the sp_prepare statement. Does the Delphi, or de ADO used by Delphi,
    puts the sp_prepare automatically when I run a query?

  • Next message: Guy Gervais: "Re: Sql or Oracle"

    Relevant Pages

    • Re: sp_prepare statement
      ... >I have an application built in Delphi, that makes a connection to SQL Server ... the querys apear to be executed ... Does the Delphi, or de ADO used by Delphi, ...
      (borland.public.delphi.database.ado)
    • Re: dbExpress or ADO?
      ... dbExpress or ADO? ... >Does the answer change for Delphi 2005? ... I would use ADO it is optimized for Microsoft's SQL server and Access. ...
      (borland.public.delphi.database.ado)
    • Automatic sp_prepare statement
      ... I have an application built in Delphi, that makes a connection to SQL Server ... the querys apear to be executed ... Does the Delphi, or de ADO used by Delphi, ...
      (borland.public.delphi.database.ado)
    • delphi 7 ADO application and sql server 2005
      ... I have to upgrade a database from 2000 to sql server 2005. ... Will my delphi 7 ado application still work properly? ... I'm just talking about delphi's ado components compatability with SQL server 2005. ...
      (borland.public.delphi.non-technical)
    • Re: Best ADO Components
      ... KaDAO seems to work with DAO - it will not work with MS SQL Server. ... uses these interfaces on low-level - and is available for Delphi 4. ... to some features not available with ADO, ... >> is a TadoDataset descendant which means you must have Borland's ADO ...
      (borland.public.delphi.database.ado)