Post reply

How can do syntax check with osql and sqlcmd

  • November 24, 2010 at 10:57 pm

    #241736

    SQL Analyzer can perform syntax check before actual SQL execution. Is there any way to do syntax check with osql and sqlmcd? thx

  • November 25, 2010 at 2:40 am

    #1255481

    AFAIK, sqlcmd and osql do not have the ability to do syntax check.

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • November 25, 2010 at 3:13 am

    #1255491

    Thx Adiga,

    Do you guy know is there any command line tool to parse SQL? thx.

  • November 25, 2010 at 3:21 am

    #1255492

    @matthew.lau,

    I am not aware of any such tools. You can try this method in sqlcmd or osql.

    SET PARSEONLY ON

    go

    <YourQuery>

    SET PARSEONLY OFF

    go

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • November 25, 2010 at 7:40 am

    #1255571

    thx Adiga, you are very helpful

  • November 25, 2010 at 8:47 pm

    #1255680

    matthew.lau (11/24/2010)

    SQL Analyzer can perform syntax check before actual SQL execution. Is there any way to do syntax check with osql and sqlmcd? thx

    I agree. They don't. I guess I don't understand why you wouldn't develop such things in SSMS, though. It's a whole lot easier to write code in SSMS than it is in NotePad (for example).

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply