How can do syntax check with osql and sqlcmd

Question

Post reply

How can do syntax check with osql and sqlcmd

matthew.lau

SSC-Addicted

Points: 424
More actions
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

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

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

Adiga One Orange Chip Points: 27284 More actions · Answer 1

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

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga

matthew.lau SSC-Addicted Points: 424 More actions · Answer 2

Thx Adiga,

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

Adiga One Orange Chip Points: 27284 More actions · Answer 3

@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

matthew.lau SSC-Addicted Points: 424 More actions · Answer 4

matthew.lau

SSC-Addicted

Points: 424

November 25, 2010 at 7:40 am

#1255571

thx Adiga, you are very helpful

Jeff Moden SSC Guru Points: 1004600 More actions · Answer 5

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)

How can do syntax check with osql and sqlcmd

Cookies on SQLServerCentral