我在网上发现一篇文章:
http://www.pinnaclepublishing.com/sq/SQMag.nsf/0/9EE2D29B4CD6750785256957006675C7?opendocument
TIP OF THE WEEK: The Mystery of SQLPARSE.DLL
Last week, I received a question from a reader who was trying to find a tool that would parse a SQL statement into columns and tables in order to determine column and table utilization. He said he'd come across a promising object called the "Microsoft SQL Parser Object Library 1.0" (SQLParse.dll), which exposed one method, ParseSQLSyntax. ParseSQLSyntax returns a tagged string of the SQL statement, but the problem is that the tags in the string don't seem to be unique for the various parts of a SQL statement (i.e. Select, From, Where, and so forth). He couldn't locate any documentation about the object and asked me if I was familiar with it. I was stumped, too, so I forwarded the question to Microsoft's Gert Drapers, who replied that SQLParse.DLL was part of Visual Studio:
Class vbSQLParser
Member of MSSQLParser
Microsoft VB SQL Parser Object 1.0 ++ Internal Use Only ++
and that it was an internal object. Mystery solved.