Checking if a string is a Sql command

Question

1.00/5 (1 vote)

See more:

C#

SQL

How would I find out if a string is in SQL syntax with out seeing if the command would work?

Posted 13-Sep-13 9:39am

shelby67

Updated 13-Sep-13 10:04am

RedDk

v2

Add a Solution

Comments

RedDk 13-Sep-13 15:43pm

First a "string" has no syntax to begin with and secondly the tools that aid in your interpretation of what a "command" is are paramount to any discussion of "checking".

shelby67 13-Sep-13 15:47pm

How would you reword what you believe it is I'm asking? (seriously)

RedDk 13-Sep-13 15:49pm

phishing, one, two, three ...

shelby67 13-Sep-13 15:58pm

...?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dave Kreskowiak · Accepted Answer · 2013-09-13T10:01:00

You have two options.

Either execute the SQL statemet against the engine that it's written for or write your own SQL Syntax Parser.

You would, of course, have to write a "pluggable" parser to support the various dialects of SQL that are out there. SQL Server does not understand Oracle, nor is the reverse true. Then there's 4th Dimension, Adabas, Alpha Five, Cassandra, Derby, Altibase, BlackRay, CA-Datacom, Clarion, Clustrix, CSSQL, CUBRID, Daffodil, DataEase, Dataphor, dBase, EnterpriseDB, FileMaker Pro, Firebird, H2, IBM DB2, Lotus Approach, Ingres, Informix, InterBase, Linter, MaxDB, Access, FoxPro, Openbase, Virtuoso, Panorama, PostgreSQL, SQLBase, RDM, SmallSQL, SQLlite, ... Those are just the ones I can remember off the top of my head. There's probably dozens more.

Good luck with that!