Hello does anyone know of a tool that will check the syntax of an SQL file and report " no syntax errors " if it is error free and tell me where a syntax error is located if there really is one? Like a compiler does for a computer program.

I need a tool, I don't just want to test it with a web site using the database. If someone claims that a database cannot be imported into another because of syntax errors I want to be able to say, take this tool and see for yourself that it is syntax error free. And if it does contain syntax errors I want to know that too.

SQL server 2005 sql data bases is what I have in mind.

Any knowledge of such a tool is very appreciated. I would buy it if nothing exist that is free.

Hi there,
SQL Server Management Studio should have that covered fine.
When you load it up and create a new query, in the menu bar above the query window, you'll see an icon of a blue tick - it's next to the Execute button. That's the syntax checker. It will tell either the query is fine or if something is wrong.

Of course it won't tell you if you've written a valid query which actually does soemthing other then you intended but then again a C# compiler woudn't do tht either.

If you're using SQL Express, SQL Management Studio Express also has this functionality.

Dan


Dan Maharry
Read the feed at http://feeds.feedburner.com/dansarchive