• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 947
  • Last Modified:

Sql Query Parser

hi all
first of all sorry for my English!

 i want code for query parser wriiten in any higher level lang.
the thing is that code should support normal select ,where ,having and group by
and everything that is needed to write an query.

actually the thing is
fieldnames and tablenames, which user gives in input query, are different from those of actual database
so i want mapp the fieldnames and tablenames with some different names and then want to form a new query which database can execute and then want to give output in users format.

so plz guide me how to do this also if there is some query parser kind of thing with code then that can be also useful or else any other advice is most wel-come.
thanks in advance
  • 2
1 Solution
Here is some source code to get you started:


On the bottom of that page you can view or download source.

The parser is implemented as a server-side JavaScript object, but should also be usable from Visual Basic or could be converted into Visual Basic without too much effort.
If you have Visual Basic, you can add a reference to the Microsoft SQL Parser and call it like any other com object....
rashmitodkarAuthor Commented:
hi arbert,
  Thank you very much for the answer!

rashmitodkarAuthor Commented:
hi arbert
 i want some documentation for this Microsoft SQL Parser,
can you tell me where could i get this documentation.

thanks in adv.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now