从SQL Server数据库2008生成KML文件 [英] Generate a KML file from SQL server Database 2008

问题描述

有人知道我如何从Sql Server数据库2008中生成.KML文件，并将KML用作Google地图上的叠加数据吗?在这方面我真的需要帮助.谢谢

Hi, does anyone know how do i generate a .KML file from Sql server Database 2008 and use the KML as overlay data on google maps ? I really need help in this . Thanks

推荐答案

您可以在select语句中使用FOR XML子句并获取XML.有关更多信息: http://msdn.microsoft.com/zh-CN /library/ms190922(v=SQL.100).aspx [ ^ ]

如果数据太复杂，则可以始终使用XML数据类型并使用存储过程等方法修改其内容.

You could possibly use FOR XML clause in a select statement and get the XML. For more info: http://msdn.microsoft.com/en-us/library/ms190922(v=SQL.100).aspx[^]

If the data is too complex, you can always use XML data type and modify it''s content for example using a stored procedure etc.

我实际上是这个领域的新手.您是否愿意详细说明以及执行的步骤?

I am actually new to this sector. do you mind to elaborate more and the steps to doing it ?

这篇关于从SQL Server数据库2008生成KML文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！