Re: Parameterized Queries

From: Jerry III (jerryiii_at_hotmail.com)
Date: 02/22/04 

Date: Sat, 21 Feb 2004 16:39:59 -0800

Yep, use the SQL Server Profiler to see what's executed.

Jerry

"Price Brattin" <pbrattin@bigfoot.com> wrote in message
news:13ccd01c3f8c8$a1ebd200$a301280a@phx.gbl...
> Is there any way to see what the generated query is when
> the Cmd.Execute method is executed. I don't mean what
> the CommandText values is but rather what the generated
> query is that is used by SQLServer.

Relevant Pages

  • Re: Automate Query
    ... Thanks very much for your prompt response, Jerry. ... Now IF the database is open and IF the form is open, the query should be ... exported to a spreadsheet somewhere between 4am and 5am every morning. ... Keith Bontrager - Bicycle Builder. ...
    (microsoft.public.access.queries)
  • Re: Different MSSQL output date format from the same PHP script
    ... Please don't delete attributions; ... Jerry suggested no such thing. ... So you're using the database as a persistence layer for your ... You wouldn't want to ever want to, say, run a query returning all ...
    (comp.lang.php)
  • RE: Error when trying to save a query
    ... Thanks so much for the advice Jerry. ... Dim TheTier As String ... Yet another option is to make a simpler query, ... INNER JOIN tblWeeks ON AND ...
    (microsoft.public.access.queries)
  • RE: Data mismatches between tables not being identified
    ... Thanks for your time on this Jerry. ... "Nuno Bento" wrote: ... The tables are linked by OriBus in NewDataMaster and BusinessUnit in Initial ... they would not appear in the query results. ...
    (microsoft.public.access.queries)
  • RE: Update Query Parameter Values
    ... Thanks Jerry, the update query is working properly now. ... "Jerry Whittle" wrote: ... The query runs fine until I view it in design view. ...
    (microsoft.public.access.queries)