November 24, 2010 at 10:57 pm
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
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
Thx Adiga,
Do you guy know is there any command line tool to parse SQL? thx.
November 25, 2010 at 3:21 am
@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
thx Adiga, you are very helpful
November 25, 2010 at 8:47 pm
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
Change is inevitable... Change for the better is not.
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy