如何在数据库内部编辑html [英] how to edit html inside a database

问题描述

您好，我最近继承了一个带有aspx页面的网站.大多数html位于SQL Server 2005数据库内部，然后aspx从那里将其拉出，以包含在default.aspx文件中.

Hi, I recently inherited a website with aspx pages. Most of the html is located inside a SQL Server 2005 database, and then aspx pulls it from there to include in the default.aspx file. Is there any tool I can use to edit the database to edit the html, or is it just TSQL I would use?

推荐答案

在Wes Aday的帮助下，我是否可以使用任何工具来编辑数据库以编辑html? ``我自己解决了这个问题.他说您必须使用SSMS(TSQL).不用了，谢谢克里斯蒂安·阿玛多(Christian Amado)，我已经用它搜索了一下，却没有找到答案.

With Wes Aday''s help I''ve solved this myself. He said you have to use SSMS (TSQL). No thanks to Christian Amado, I had googled it and found no answer.

您好，

如果数据库中的HTML内容是 XHTML ，则可以使用数据库中的XML数据类型来做到这一点.您可以直接在数据库中更新特定信息.

以下是一些有用的链接，可能会对您有所帮助，

XQuery和XMLDML [ Scritp在数据库中插入/更新xml数据 [

Hi,

If your HTML content in the database is XHTML then you can do that using XML datatype in the database. you can update specific information directly in the database.

Below are some useful links that may help you,

XQuery and XMLDML[^]

Scritp to insert/Update xml data in database[^]

Hope this helps you
Thanks
-Amit Gajjar

网上有个很酷的网站.当您学习使用该站点时，我所说的站点非常有用.

该站点就像一个瓶中的天才.唯一的区别是您根本不应该擦拭灯泡.只需在此处输入问题即可:)

您可以在此处找到该网站.

您可以在Web表达式中的sql内部复制html或任何其他工具.

希望您会发现它有用.

There is a very cool site around the net. The site what I talking about is very useful when you learn to use it.

That site is like a genius in a bottle. The only difference is that you should not rub the lamp at all. Just type your questions there :)

The site you can find here.

You can copy your html inside sql in Web Expression or any another tool.

Hope you can find it useful.

这篇关于如何在数据库内部编辑html的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！