将大型SQL查询存储到XML中 [英] to store large sql query into an xml

问题描述

嗨

是否可以将大型sql查询存储到xml文件中并从xml文件读取以执行.如果是这样，请提供一个示例XML，其中XML文件中存储了多行sql语句

Is it possible to store a large sql query into an xml file and to read from xml file to execute. If so, Please can you give an example xml with more than one line sql statement stored in xml file

致谢

Pol

polachan

推荐答案

那将需要您知道如何使用SQLDataReader.

That would require you to know how to use a SQLDataReader.

https://dev.mysql.com/doc/dev/connector-net /html/T_MySql_Data_MySqlClient_MySqlDataReader.htm

上面的链接使用列序号位置，我怀疑您可以使用列名，就像可以使用MS SQL Server DataReader一样.是的，使用列名查找一个MS示例.

The above link is using column ordinal position, and I suspect you can use a column name, like you can do it with a MS SQL Server DataReader. Yeah go find a MS example using column name. 

这将要求您知道如何使用XMLTextWriter或 来编写XML.使用XML文档，您可以使用Bing或Google查找该文档.

It would require you to know how to write XML by using a XMLTextWriter or  using a XML Document, which you can look up by using Bing or Google.

这篇关于将大型SQL查询存储到XML中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！