寻找.NET的T-SQL Parser [英] looking for a T-SQL Parser for .NET
问题描述
对不起，我不知道在哪一边
我能找到这样的东西。我正在寻找.NET中的T-SQL解析器，
生成一个抽象语法树。理想情况下，它也应该能够
解析存储过程。我不想自己写一个
，但愿意继续工作，以防有人
已经开始工作了。
感谢您的任何意见，
Eduard Ralph
Hi,
sorry for the cross-post but I''m a bit unsure on which side of the line
I could find such things. I''m looking for a T-SQL Parser in .NET that
produces an abstract syntax tree. Ideally it should also be able to
parse Stored Procedures as well. I would hate to have to write one
myself but would be willing to continue the work on it in case someone
has already started working on it.
Thanks for any input,
Eduard Ralph
推荐答案
Eduard，
为什么要完全解析TSQL？通常是'SQL Server'的工作。
Eduard,
Why would you want to parse TSQL at all? Usually that''s SQL Server''s
job.
" Alexander Kuznetsov" < AK ************ @ hotmail.COM>在消息中写道
news：11 ********************* @ g10g2000cwb.googlegro ups.com ...
"Alexander Kuznetsov" <AK************@hotmail.COM> wrote in message
news:11*********************@g10g2000cwb.googlegro ups.com...
Eduard，
为什么要完全解析TSQL？通常是'SQL Server'的工作。
Eduard,
Why would you want to parse TSQL at all? Usually that''s SQL Server''s
job.
唉，我知道一切原因：MS没有制作QA SQL编辑器
组件可供重用。我有自己的工具来创建存储的
程序等瘦客户端和胖客户端，并且在这两种情况下我都没有彩色文本而没有彩色文本因为没有合理的文本好的T-SQL解析器
那里，.NET或其他。
Paul
Alas, I know all to well a reason: MS does not make its QA SQL editor
component available for reuse. I have my own tools to author stored
procedures and such in both thin and thick client, and in both cases I have
to go without colored text because there is no reasonably good T-SQL parser
out there, .NET or otherwise.
Paul
PJ6写道：
PJ6 wrote:
我有自己的工具来创建存储的
程序等瘦客户端和胖客户端，在这两种情况下我都有
没有彩色文本，因为那里没有相当好的T-SQL解析器，.NET或其他。
I have my own tools to author stored
procedures and such in both thin and thick client, and in both cases I have
to go without colored text because there is no reasonably good T-SQL parser
out there, .NET or otherwise.
COM组件Microsoft SQL Parser对象图书馆（SQLPARSE.DLL）
相当不错，IMO。
杰米。
-
The COM component Microsoft SQL Parser Object Library (SQLPARSE.DLL) is
reasonably good, IMO.
Jamie.
--
这篇关于寻找.NET的T-SQL Parser的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
