vb.net中的SQL查询解析 [英] SQL query parsing in vb.net
问题描述
我已经在网上搜索了很多资源以进行解析.解析为整数,解析为char,解析为字符串.但是我只是无法创建一个程序来解析SQL查询并进行转换
I already searched a lot of resources on the net for parsing. Parsing in integers, parsing in char, parsing in string. However I just can't create a program that will parse a SQL Query and do conversion
例如,从MySQL到MsSQL.
For example, MySQL to MsSQL.
有人有一些示例查询转换代码或相关链接吗?
Does anybody have some sample query conversion code or relavent links?
推荐答案
从一个数据库到另一个数据库的SQL转换非常复杂,有很多事情要做,例如数据类型转换,不同的函数语法,适当的连接语法和存储过程很难转换.
SQL conversion from one database to another is quite complicated, there are lots of things to do such as data type conversion, different syntax of functions, propriety join syntax and stored procedure is much more difficult to convert.
这里有两篇带有真实演示的文章,可以进行一些SQL查询转换.
Here are two articles with real demo to do some SQL query conversion.
- Rewrite Oracle propriety joins to ANSI SQL compliant joins.
- Rewrite SQL Server proprietary joins to ANSI SQL compliant joins.
这篇关于vb.net中的SQL查询解析的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!