Re: sp_prepare statement

From: Brian Bushay TeamB (BBushay_at_Nmpls.com)
Date: 12/31/04

  • Next message: Brian Bushay TeamB: "Re: Row cannot be located for updating error (ADO)" 
    Date: Thu, 30 Dec 2004 20:43:03 -0600

    >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?
    SQL server will convert your queries to Stored procedures is that what you are
    referring to? 

    --
Brian Bushay (TeamB)
Bbushay@NMPLS.com
  • Next message: Brian Bushay TeamB: "Re: Row cannot be located for updating error (ADO)"

    Relevant Pages

    • 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)