Re: Syntax Check

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Pablo Castro [MS] (pablocas_at_online.microsoft.com)
Date: 02/24/05 

Date: Wed, 23 Feb 2005 18:48:00 -0800

Sorry, I should have clarified. SET PARSEONLY ON|OFF will only actually
parse the statement; binding won't happen, so you won't get errors that are
not related to syntax such as invalid table names.

If this is a select query, you can use SET FMTONLY ON, which will return an
empty resultset instead of returning all the values. This also works for
trivial DML statements (they won't cause side-effects), but I don't remember
off the top of my head whether there are potential problems with relying on
SET FMTONLY ON for DML. 

-- 
Pablo Castro
Program Manager - ADO.NET Team
Microsoft Corp.
This posting is provided "AS IS" with no warranties, and confers no rights.
"Cathie Hagen" <cathie@bob.com> wrote in message
news:u$Z5PVWGFHA.1408@TK2MSFTNGP10.phx.gbl...
> Actually I spoke too soon.  SET PARSEONLY ON still executes the query when
> run in SQL Query Analyser.  I have tried SET NOEXEC ON but that only
checks
> the syntax and doesn't report back if the Column or Table names are
invalid.
>
> Any other ideas?
> Cathie
>
> "Pablo Castro [MS]" <pablocas@online.microsoft.com> wrote in message
> news:%23lHDZEWGFHA.3648@TK2MSFTNGP09.phx.gbl...
> > If you're running against SQL Server, you can use "SET PARSEONLY
ON|OFF".
> > Check out books online for details on PARSEONLY. The short story is that
> > you
> > can execute that before your statement so the server parses the
statement
> > and generates an error if there is a syntax error, but the statement
never
> > actually gets executed. Make sure you revert it to OFF before trying to
> > execute something for real.
> >
> > -- 
> > Pablo Castro
> > Program Manager - ADO.NET Team
> > Microsoft Corp.
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> >
> >
> > "Cathie Hagen" <cathie@bob.com> wrote in message
> > news:uDaBA%23VGFHA.2180@TK2MSFTNGP12.phx.gbl...
> >> Hi All,
> >>
> >> Is there a way to do a syntax check on the statement without executing
> >> it?
> >>
> >> Cathie
> >>
> >>
> >
> >
>
>

Relevant Pages

  • Re: parse to execute ratio too high
    ... I know the the question isn't inusual, but i 've a problem with parse ... My parse to execute ratio it's 62% and it's very high value the ... session cursor cache hits, then your problem ...
    (comp.databases.oracle.server)
  • Re: Waveform Mini-Language
    ... The syntax might seem strange at first, ... Got any ideas for how to make a "go" command ... How about "Frequency 500 Hz Voltage 20 Volts Set"? ... Frequency would error check and execute it. ...
    (comp.arch.embedded)
  • Re: parse to execute ratio too high
    ... I know the the question isn't inusual, but i 've a problem with parse ... My parse to execute ratio it's 62% and it's very high value the ... response times sometimes aren't good. ...
    (comp.databases.oracle.server)
  • Re: Delimiters for comments
    ... Python uses the syntax ... If you have a bottom-up language you will be forced to resolve ambiguities ... any number from 3 upwards would execute the 3+ action. ... use *same* syntax for it and for the case statement. ...
    (comp.lang.misc)
  • Re: parse to execute ratio too high
    ... I know the the question isn't inusual, but i 've a problem with parse ... My parse to execute ratio it's 62% and it's very high value the ... session cursor cache hits, then your problem ...
    (comp.databases.oracle.server)