Re: Pls recommend a replacement for Microsoft Query

From: Jamie Collins (jamiecollins_at_xsmail.com)
Date: 07/20/04 

Date: 20 Jul 2004 00:55:12 -0700

"Vadim Rapp" <vrapp@nospam.polyscience.com> wrote ...

> If the sql query is any less than trivial, MS Query says that it can't be
> displayed graphically. And if it can't be displayed graphically, then it
> can't have parameters.

That doesn't sound correct. If the sql is any less than trivial, MS
Query passes it to the DB server for execution, so it is a question of
whether your DBMS supports parameters. SQL Server certainly does.

The best approach is to create a stored procedure, with input
parameters, on the server and call the stored proc from Excel. You can
use MS Query to call the proc (even create it if you have the
permissions!). However, for a more capable data access technology,
which you will undoubtedly already have, check out ADO.

Jamie. 

--

Relevant Pages

  • Re: Weird performance issue ....
    ... If I understand - the problem is with a query returned from a stored proc ... "a query making a user function call" you mean something different again). ... as PL/SQL is assumed to be a "batch" environment. ... Not taking about power since where the issue is, the server ...
    (comp.databases.oracle.server)
  • Dynamic distributed SQL query needs ANSI_NULLS & ANSI_WARNINGS but cant set them
    ... The user has to supply the linked server name and database. ... the stored procedure is being run, ... This ensures consistent query semantics. ...
    (microsoft.public.sqlserver.server)
  • Dynamic distributed SQL query needs ANSI_NULLS & ANSI_WARNINGS but cant set them
    ... The user has to supply the linked server name and database. ... the stored procedure is being run, ... This ensures consistent query semantics. ...
    (microsoft.public.sqlserver.programming)
  • Distributed queries and Crystal Reports
    ... And naturally the stored procedure runs fine from the Query ... set for the connection. ... server access as dynamic sql, function, etc. ...
    (microsoft.public.sqlserver.programming)
  • Query very slow from IIS, fast from other clients
    ... I have a query, written as a stored procedure, that takes one ... Delphi program to run the same query and measure the time taken: ... on the server, I can see the processor getting busy for the 20 seconds ... It's not the connection that differs. ...
    (microsoft.public.sqlserver.clients)
Quantcast