SQL Server中的XML数据进行insert、update、delete

sql Server中新增加了XML.Modify()方法，分别为xml.modify(insert),xml.modify(delete),xml.modify(replace)对应XML的插入，删除和修改操作。
本文以下面XML为例，对三种DML进行说明：
declare
@XMLVar xml = '

<book category="ITPro">
Windows Step By Step@H_<a href="/tag/403/" target="_blank" class="keywords">403</a><em>8@ <BR><author>Bill Zack</author> <BR><price>49.99</price> <BR></book> <BR><book category="Developer"> <BR><title>Developing ADO .NET@H</em><a href="/tag/403/" target="_blank" class="keywords">403</a><em>8@ <BR><author>Andrew Brust</author> <BR><price>39.93</price> <BR></book> <BR><book category="ITPro"> <BR><title>Windows Cluster Server@H</em><a href="/tag/403/" target="_blank" class="keywords">403</a><em>8@ <BR><author>Stephen Forte</author> <BR><price>59.99</price> <BR></book> <BR></catalog> <BR>' <BR>1.XML.Modify(Insert)语句介绍 <BR>A.利用as first,at last,before,after四个参数将元素插入指定的位置 <BR>set <BR>@XMLVar.modify <BR>( <BR>'insert <first name="at first" /> as first into (/catalog[1]/book[1])' <BR>) <BR>set <BR>@XMLVar.modify <BR>( <BR>'insert <last name="at last"/> as last into (/catalog[1]/book[1])' <BR>) <BR>set <BR>@XMLVar.modify <BR>( <BR>'insert <before name="before"/> before (/catalog[1]/book[1]/author[1])' <BR>) <BR>set <BR>@XMLVar.modify <BR>( <BR>'insert <after name="after"/> after (/catalog[1]/book[1]/author[1])' <BR>) <BR>SELECT <BR>@XMLVar.query('/catalog[1]/book[1]' <BR>); <BR>结果集为： <BR><book category="ITPro" <BR>> <BR><first name="at first" <BR>/> <BR><title>Windows Step By Step@H</em><a href="/tag/403/" target="_blank" class="keywords">403</a>_8@ <BR><before name="before" <BR>/> <BR><author>Bill Zack</author> <BR><after name="after" <BR>/> <BR><price>49.99</price> <BR><last name="at last" <BR>/> <BR></book> <BR>B.将多个元素插入文档中 <BR>--<a href="/tag/fangfa/" target="_blank" class="keywords">方法</a>一：利用变量进行插入 <BR>DECLARE @newFeatures xml; <BR>SET @newFeatures = N' <first>one element</first> <BR><second>second element</second>' <BR>SET @XMLVar.modify(' <BR>) <BR>insert <a href="/tag/sql/" target="_blank" class="keywords">sql</a>:variable("@newFeatures") <BR>into (/catalog[1]/book[1])' <BR>--<a href="/tag/fangfa/" target="_blank" class="keywords">方法</a>二：直接插入 <BR>set @XMLVar.modify(' <BR>) <BR>insert (<first>one element</first>,<second>second element</second>) <BR>into (/catalog[1]/book[1]/author[1])' <BR>SELECT @XMLVar.query('/catalog[1]/book[1]' <BR>); <BR>结果集为： <BR>1: <BR>< <BR>book <BR>category <BR>="ITPro" <BR>> <BR>2: <BR>< <BR>title <BR>> <BR>Windows Step By Step</ <BR>title <BR>> <BR>3: <BR>< <BR>author <BR>> <BR>Bill Zack <BR>4: <BR>< <BR>first <BR>> <BR>one element</ <BR>first <BR>> <BR>5: <BR>< <BR>second <BR>> <BR>second element</ <BR>second <BR>> <BR>6: <BR></ <BR>author <BR>> <BR>7: <BR>< <BR>price <BR>> <BR>49.99</ <BR>price <BR>> <BR>8: <BR>< <BR>first <BR>> <BR>one element</ <BR>first <BR>> <BR>9: <BR>< <BR>second <BR>> <BR>second element</ <BR>second <BR>> <BR>10: <BR></ <BR>book <BR>> <BR>C.将<a href="/tag/shuxing/" target="_blank" class="keywords">属性</a>插入文档中 <BR>--使用变量插入 <BR>declare @var nvarchar(10) = '变量插入' <BR>set @XMLVar.modify( <BR>'insert (attribute var {<a href="/tag/sql/" target="_blank" class="keywords">sql</a>:variable("@var")}) <BR>) <BR>into (/catalog[1]/book[1])' <BR>--直接插入 <BR>set @XMLVar.modify( <BR>'insert (attribute name {"直接插入"}) <BR>) <BR>into (/catalog[1]/book[1]/title[1])' <BR>--多值插入 <BR>set @XMLVar.modify( <BR>'insert (attribute Id {"多值插入1"},attribute name {"多值插入2"}) <BR>) <BR>into (/catalog[1]/book[1]/author[1])' <BR>SELECT @XMLVar.query('/catalog[1]/book[1]' <BR>); <BR>结果集为： <BR>1: <BR><book category="ITPro" <BR>var="变量插入" <BR>> <BR>2: <BR><title name="直接插入" <BR>>Windows Step By Step@H_<a href="/tag/403/" target="_blank" class="keywords">403</a>_8@ <BR>3: <BR><author Id="多值插入1" <BR>name="多值插入2" <BR>>Bill Zack</author> <BR>4: <BR><price>49.99</price> <BR>5: <BR></book> <BR>D.插入文本节点 <BR>set <BR>@XMLVar.modify <BR>( <BR>'insert text{"at first"} as first <BR>) <BR>into (/catalog[1]/book[1])' <BR>SELECT <BR>@XMLVar.query('/catalog[1]/book[1]' <BR>); <BR>结果集为： <BR>1: <BR>< <BR>book <BR>category <BR>="ITPro" <BR>> <BR>2: <BR>at first <BR>3: <BR>< <BR>title <BR>> <BR>Windows Step By Step</ <BR>title <BR>> <BR>4: <BR>< <BR>author <BR>> <BR>Bill Zack</ <BR>author <BR>> <BR>5: <BR>< <BR>price <BR>> <BR>49.99</ <BR>price <BR>> <BR>6: <BR></ <BR>book <BR>> <BR>注意：插入本文同样具体 as first，as last，before，after四种选项，可以参考A中的使用<a href="/tag/fangfa/" target="_blank" class="keywords">方法</a> <BR>E.插入注释节点 <BR>set @XMLVar.modify( <BR>'insert  <BR>) <BR>before (/catalog[1]/book[1]/title[1])' <BR>SELECT @XMLVar.query('/catalog[1]/book[1]' <BR>); <BR>结果集为： <BR>1: <BR><book category="ITPro" <BR>> <BR>2: <BR> <BR>3: <BR><title>Windows Step By Step@H_<a href="/tag/403/" target="_blank" class="keywords">403</a>_8@ <BR>4: <BR><author>Bill Zack</author> <BR>5: <BR><price>49.99</price> <BR>6: <BR></book> <BR>注意插入注释节点同样具体 as first，as last，before，after四种选项，可以参考A中的使用<a href="/tag/fangfa/" target="_blank" class="keywords">方法</a> <BR>F.插入处理指令 <BR>set @XMLVar.modify( <BR>'insert <?Program "Instructions.exe" ?> <BR>) <BR>before (/catalog[1]/book[1]/title[1])' <BR>SELECT @XMLVar.query('/catalog[1]/book[1]' <BR>); <BR>结果集为： <BR>1: <bookcategory="ITPro"> <BR>2: <?Program"Instructions.exe"?> <BR>3: <title>Windows Step By Step@H_<a href="/tag/403/" target="_blank" class="keywords">403</a>_8@ <BR>4: <author>Bill Zack</author> <BR>5: <price>49.99</price> <BR>6: </book> <BR>注意插入处理指令同样具体 as first，as last，before，after四种选项，可以参考A中的使用<a href="/tag/fangfa/" target="_blank" class="keywords">方法</a> <BR>G.根据 if 条件语句进行插入 <BR>set @XMLVar.modify( <BR>'insert <BR>) <BR>if (/catalog[1]/book[1]/title[2]) then <BR>text{"this is a 1 step"} <BR>else ( text{"this is a 2 step"} ) <BR>into (/catalog[1]/book[1]/price[1])' <BR>SELECT @XMLVar.query('/catalog[1]/book[1]' <BR>); <BR>结果集为： <BR>1: <book category="ITPro"> <BR>2: <title>Windows Step By Step@H_<a href="/tag/403/" target="_blank" class="keywords">403</a>_8@ <BR>3: <author>Bill Zack</author> <BR>4: <price>49.99this isa 2 step</price> <BR>5: </book> <BR>2.XML.Modify(delete)语句介绍 <BR>--<a href="/tag/shanchu/" target="_blank" class="keywords">删除</a><a href="/tag/shuxing/" target="_blank" class="keywords">属性</a> <BR>set @XMLVar.modify('delete /catalog[1]/book[1]/@category') <BR>--<a href="/tag/shanchu/" target="_blank" class="keywords">删除</a>节点 <BR>set @XMLVar.modify('delete /catalog[1]/book[1]/title[1]') <BR>--<a href="/tag/shanchu/" target="_blank" class="keywords">删除</a><a href="/tag/neirong/" target="_blank" class="keywords">内容</a> <BR>set @XMLVar.modify('delete /catalog[1]/book[1]/author[1]/text()') <BR>--全部<a href="/tag/shanchu/" target="_blank" class="keywords">删除</a> <BR>set @XMLVar.modify('delete /catalog[1]/book[2]') <BR>SELECT @XMLVar.query('/catalog[1]'); <BR>结果集为： <BR>1: <catalog> <BR>2: <book> <BR>3: <author /> <BR>4: <price>49.99</price> <BR>5: </book> <BR>6: <book category="ITPro"> <BR>7: <title>Windows Cluster Server@H_<a href="/tag/403/" target="_blank" class="keywords">403</a>_8@ <BR>8: <author>Stephen Forte</author> <BR>9: <price>59.99</price> <BR>10: </book> <BR>11: </catalog> <BR>3.XML.Modify(replace)语句介绍 <BR>--替换<a href="/tag/shuxing/" target="_blank" class="keywords">属性</a> <BR>set @XMLVar.modify('replace value of(/catalog[1]/book[1]/@category)) <BR>with ("替换<a href="/tag/shuxing/" target="_blank" class="keywords">属性</a>")' <BR>--替换<a href="/tag/neirong/" target="_blank" class="keywords">内容</a> <BR>set @XMLVar.modify('replace value of(/catalog[1]/book[1]/author[1]/text()[1])) <BR>with("替换<a href="/tag/neirong/" target="_blank" class="keywords">内容</a>")' <BR>--条件替换 <BR>set @XMLVar.modify('replace value of (/catalog[1]/book[2]/@category)) <BR>with( <BR>if(count(/catalog[1]/book)>4) then <BR>"条件替换1" <BR>else <BR>"条件替换2")' <BR>SELECT @XMLVar.query('/catalog[1]' <BR>); <BR>结果集为： <BR>1: <catalog> <BR>2: <bookcategory="替换<a href="/tag/shuxing/" target="_blank" class="keywords">属性</a>"> <BR>3: <title>Windows Step By Step@H_<a href="/tag/403/" target="_blank" class="keywords">403</a>_8@ <BR>4: <author>替换<a href="/tag/neirong/" target="_blank" class="keywords">内容</a></author> <BR>5: <price>49.99</price> <BR>6: </book> <BR>7: <bookcategory="条件替换2"> <BR>8: <title> <BR>Developing ADO .NET@H_<a href="/tag/403/" target="_blank" class="keywords">403</a><em>8@ <BR>9: <BR><author> <BR>Andrew Brust</author> <BR>10: <price>39.93</price> <BR>11: </book> <BR>12: <bookcategory="ITPro"> <BR>13: <title>Windows Cluster Server@H</em><a href="/tag/403/" target="_blank" class="keywords">403</a>_8@ <BR>14: <author>Stephen Forte</author> <BR>15: <price>59.99</price> <BR>16: </book> <BR>17: </catalog></p></div> <div class="topcard-tags"><a href="/tag/delete/" class="tag_link" target="_blank">delete</a><a href="/tag/pdelete/" class="tag_link" target="_blank">delete</a><a href="/tag/deletep/" class="tag_link" target="_blank">delete</a><a href="/tag/insert/" class="tag_link" target="_blank">insert</a><a href="/tag/insertp/" class="tag_link" target="_blank">insert</a><a href="/tag/update/" class="tag_link" target="_blank">update</a><a href="/tag/updatep/" class="tag_link" target="_blank">update</a><a href="/tag/pupdate/" class="tag_link" target="_blank">update</a><a href="/tag/pXMLp-1/" class="tag_link" target="_blank">XML</a></div> <ul class="list-group"> <li class="list-group-item"><a href="/mssql/66433.html" title="SQL2005 ROW_NUMER实现分页的两种常用方式">上一篇：SQL2005 ROW_NUMER实现分页的两种常</a><a href="/mssql/66431.html" title="在安装sql2005中或安装后sa用户无法登陆系统解决方法" class="text-muted pull-right">下一篇：在安装sql2005中或安装后sa用户无法</a> </li> </ul> </div> </div> </div>  <div class="row row-sm"> <div class="col-sm-12 col-md-12 col-lg-12"> <div class="card"> <ins class="adsbygoogle" style="display:block" data-ad-format="autorelaxed" data-ad-client="ca-pub-4605373693034661" data-ad-slot="9144498553"></ins> <script> (adsbygoogle = window.adsbygoogle || []).push({}); </script></div> </div> </div> <div class="row row-sm"> <div class="col-sm-12 col-md-12 col-lg-12"> <div class="card"> <div class="title"><h1>猜你在找的MsSQL相关文章</h1></div> <div class="list_con"> <a href="/mssql/997614.html" title="SQL Server2012高可用之日志传送测试"><img class="lazy" src="/images/np.jpg" data-original="/res/2021/02-21/08/fdbc8556787671fc4c3deab3c9d18cab.png" title="" width="160" height="90" style="float:right;margin-left:30px;display:none;" /><div class="title">SQL Server2012高可用之日志传送测试</div> <div class="summary">（一）日志传送架构（1.1）相关服务器主服务器：用于生产的服务器，上面运行这生产SQL ...</div> <time class="summary">作者：前端之家时间：2021-02-21</time> </a> </div> <div class="list_con"> <a href="/mssql/997613.html" title="SQL server事物复制报错：要复制的 LOB 数据的长度(xxxxx)超出了配置的最大值 65536"><img class="lazy" src="/images/np.jpg" data-original="/res/2021/02-21/08/0545584a6bc1583b4f5945853d88cbee.png" title="" width="160" height="90" style="float:right;margin-left:30px;display:none;" /><div class="title">SQL server事物复制报错：要复制的 LOB 数据的长度(xxxxx)超出了配置的最大值 65536</div> <div class="summary">(一)事故背景最近在SQL Server 2012生产数据库上配置完事物复制（发布订阅）后，生产数据...</div> <time class="summary">作者：前端之家时间：2021-02-21</time> </a> </div> <div class="list_con"> <a href="/mssql/997612.html" title="SQL Server2012高可用之事物复制(发布订阅)测试"><img class="lazy" src="/images/np.jpg" data-original="/res/2021/02-21/08/bce5b1e4ace4b6110eccc85d48a5af4e.png" title="" width="160" height="90" style="float:right;margin-left:30px;display:none;" /><div class="title">SQL Server2012高可用之事物复制(发布订阅)测试</div> <div class="summary">（一）测试目的目前公司使用的SQL SERVER 2012高可用环境为主备模式，其中主库可执行读写...</div> <time class="summary">作者：前端之家时间：2021-02-21</time> </a> </div> <div class="list_con"> <a href="/mssql/997611.html" title="使用zabbix监控sql server的发布订阅"><img class="lazy" src="/images/np.jpg" data-original="/res/2021/02-21/08/86cd603531c52a87547e0b7a19df16de.png" title="" width="160" height="90" style="float:right;margin-left:30px;display:none;" /><div class="title">使用zabbix监控sql server的发布订阅</div> <div class="summary">（一）背景个人在使用sql server时，用到了sql server的发布订阅来做主从同步，类似MySQL的...</div> <time class="summary">作者：前端之家时间：2021-02-21</time> </a> </div> <div class="list_con"> <a href="/mssql/994907.html" title="SQL学习（四）集合运算"><div class="title">SQL学习（四）集合运算</div> <div class="summary">UNION和OR谓词找出 product 和 product2 中售价高于 500 的商品的基本信息. select * fro...</div> <time class="summary">作者：前端之家时间：2021-01-12</time> </a> </div> <div style="border-bottom: 1px solid #f4f4f4;margin-top:20px;"> <ins class="adsbygoogle" style="display:block" data-ad-format="fluid" data-ad-layout-key="-fr-2o+fp-dx-wx" data-ad-client="ca-pub-4605373693034661" data-ad-slot="4561116489"></ins> <script> (adsbygoogle = window.adsbygoogle || []).push({}); </script> </div><div class="list_con"> <a href="/mssql/994905.html" title="SQL学习（五）高级处理"><div class="title">SQL学习（五）高级处理</div> <div class="summary">5.1 请说出针对本章中使用的 product（商品）表执行如下 SELECT 语句所能得到的结果。 SEL...</div> <time class="summary">作者：前端之家时间：2021-01-12</time> </a> </div> <div class="list_con"> <a href="/mssql/994904.html" title="SQL学习(一）初识数据库"><img class="lazy" src="/images/np.jpg" data-original="/res/2021/01-12/08/0318d1ac8991dd6ef965dd7c2f8303ff.png" title="" width="160" height="90" style="float:right;margin-left:30px;display:none;" /><div class="title">SQL学习(一）初识数据库</div> <div class="summary">datawhale组队学习SQL task01</div> <time class="summary">作者：前端之家时间：2021-01-12</time> </a> </div> <div class="list_con"> <a href="/mssql/994903.html" title="SQL学习(二）基础查询与排序"><img class="lazy" src="/images/np.jpg" data-original="/res/2021/01-12/08/b829b4ffc0c5b6d9fa58221f3b2d5736.png" title="" width="160" height="90" style="float:right;margin-left:30px;display:none;" /><div class="title">SQL学习(二）基础查询与排序</div> <div class="summary">datawhale数据库组队学习第二天打卡</div> <time class="summary">作者：前端之家时间：2021-01-12</time> </a> </div> <div class="list_con"> <a href="/mssql/871914.html" title="SQL Server 2005 返回修改后的数据"><img class="lazy" src="/images/np.jpg" data-original="/res/2020/11-03/09/41fba75a9fe74d5ee33749280d5f415d.jpg" title="" width="160" height="90" style="float:right;margin-left:30px;display:none;" /><div class="title">SQL Server 2005 返回修改后的数据</div> <div class="summary">今天在公司看到同事写了个SQL2005的新特性的文章，觉得很实用，在这里和大家分享下。原著作...</div> <time class="summary">作者：前端之家时间：2020-11-06</time> </a> </div> <div class="list_con"> <a href="/mssql/871913.html" title="SQL Server 数据库最小宕机迁移方案"><div class="title">SQL Server 数据库最小宕机迁移方案</div> <div class="summary">一、目的在做SQL Server数据库维护的时候，当上司要求我们把几十G的数据文件搬动到其它服...</div> <time class="summary">作者：前端之家时间：2020-11-06</time> </a> </div> <div style="border-bottom: 1px solid #f4f4f4;margin-top:20px;"> <ins class="adsbygoogle" style="display:block" data-ad-format="fluid" data-ad-layout-key="-fr-2o+fp-dx-wx" data-ad-client="ca-pub-4605373693034661" data-ad-slot="4561116489"></ins> <script> (adsbygoogle = window.adsbygoogle || []).push({}); </script> </div></div> </div> </div> </div>   <div class="col-sm-12 col-md-12 col-lg-3">  <div class="row row-sm"> <div class="col-sm-12 col-md-12 col-lg-12"> <div class="card"> <label class="main-content-label ">编程分类</label> <div class="cate mt-20"><a href="/mysql/" title="MySQL">MySQL</a><a href="/mssql/" title="MsSQL">MsSQL</a><a href="/oracle/" title="Oracle">Oracle</a><a href="/sqlite/" title="Sqlite">Sqlite</a><a href="/postgresql/" title="Postgre SQL">Postgre SQL</a><a href="/mariadb/" title="Mariadb">Mariadb</a><a href="/mongodb/" title="MongoDB">MongoDB</a><a href="/nosql/" title="NoSQL">NoSQL</a><a href="/hbase/" title="HBase">HBase</a><a href="/jdbc/" title="JDBC">JDBC</a><div class="clearfix"></div> </div> </div> </div> </div>   <div class="row row-sm"> <div class="col-sm-12 col-md-12 col-lg-12"> <div class="card">  <ins class="adsbygoogle" style="display:block" data-ad-client="ca-pub-4605373693034661" data-ad-slot="7756441254" data-ad-format="auto" data-full-width-responsive="true"></ins> <script> (adsbygoogle = window.adsbygoogle || []).push({}); </script> </div> </div> </div>   <div class="row row-sm"> <div class="col-sm-12 col-md-12 col-lg-12"> <div class="card"> <label class="main-content-label ">最新文章</label> <ul class="n-list"><li><a href="/mssql/997614.html" title="SQL Server2012高可用之日志传送测试" target="_blank">• SQL Server2012高可用之日</a></li> <li><a href="/mssql/997613.html" title="SQL server事物复制报错：要复制的 LOB 数据的长度(xxxxx)超出了配置的最大值 65536" target="_blank">• SQL server事物复制报错：</a></li> <li><a href="/mssql/997612.html" title="SQL Server2012高可用之事物复制(发布订阅)测试" target="_blank">• SQL Server2012高可用之事</a></li> <li><a href="/mssql/997611.html" title="使用zabbix监控sql server的发布订阅" target="_blank">• 使用zabbix监控sql server</a></li> <li><a href="/mssql/994907.html" title="SQL学习（四）集合运算" target="_blank">• SQL学习（四）集合运算</a></li> <li><a href="/mssql/994906.html" title="SQL学习(三）复杂查询" target="_blank">• SQL学习(三）复杂查询</a></li> <li><a href="/mssql/994905.html" title="SQL学习（五）高级处理" target="_blank">• SQL学习（五）高级处理</a></li> <li><a href="/mssql/994904.html" title="SQL学习(一）初识数据库" target="_blank">• SQL学习(一）初识数据库</a></li> <li><a href="/mssql/994903.html" title="SQL学习(二）基础查询与排序" target="_blank">• SQL学习(二）基础查询与排</a></li> <li><a href="/mssql/871914.html" title="SQL Server 2005 返回修改后的数据" target="_blank">• SQL Server 2005 返回修改</a></li> </ul> </div> </div> </div>   <div class="row row-sm"> <div class="col-sm-12 col-md-12 col-lg-12"> <div class="card"> <label class="main-content-label ">热门标签 <span class="pull-right tx-12"> <a href="/all" target="_blank">更多 ►</a></span> </label> <div class="topcard-tags"><a href="/tag/undorizhi/" title="undo日志" target="_blank">undo日志</a><a href="/tag/persistentconnection/" title="persistent-connection" target="_blank">persistent-c</a><a href="/tag/mysqlerror1005/" title="mysql-error-1005" target="_blank">mysql-error-</a><a href="/tag/postalcode/" title="postal-code" target="_blank">postal-code</a><a href="/tag/sqlmatchall/" title="sql-match-all" target="_blank">sql-match-al</a><a href="/tag/mysql56/" title="mysql-5.6" target="_blank">mysql-5.6</a><a href="/tag/mysql80/" title="mysql-8.0" target="_blank">mysql-8.0</a><a href="/tag/databasetrigger/" title="database-trigger" target="_blank">database-tri</a><a href="/tag/anzhuanglujing/" title="安装路径" target="_blank">安装路径</a><a href="/tag/xitongcuowu/" title="系统错误" target="_blank">系统错误</a><a href="/tag/datadir/" title="data_dir" target="_blank">data_dir</a><a href="/tag/diushiwenjian/" title="丢失文件" target="_blank">丢失文件</a><a href="/tag/zhucongtongbu/" title="主从同步" target="_blank">主从同步</a><a href="/tag/sqlmode/" title="sql_mode" target="_blank">sql_mode</a><a href="/tag/shujukumulu/" title="数据库目录" target="_blank">数据库目录</a><a href="/tag/nimingyonghu/" title="匿名用户" target="_blank">匿名用户</a><a href="/tag/charactersetserver/" title="character_set_server" target="_blank">character_se</a><a href="/tag/IDguiling/" title="ID归零" target="_blank">ID归零</a><a href="/tag/shujukuweizhi/" title="数据库位置" target="_blank">数据库位置</a><a href="/tag/chaxunbiao/" title="查询表" target="_blank">查询表</a><a href="/tag/zhongfuziduan/" title="重复字段" target="_blank">重复字段</a><a href="/tag/chaxunziduan/" title="查询字段" target="_blank">查询字段</a><a href="/tag/jieduanrizhi/" title="截断日志" target="_blank">截断日志</a><a href="/tag/SUSPECT/" title="SUSPECT" target="_blank">SUSPECT</a><a href="/tag/7391/" title="7391" target="_blank">7391</a><a href="/tag/RemoteServer/" title="Remote Server" target="_blank">Remote Serve</a><a href="/tag/LinkedServer/" title="Linked Server" target="_blank">Linked Serve</a><a href="/tag/xuanxuewenti/" title="玄学问题" target="_blank">玄学问题</a><a href="/tag/denglubushang/" title="登录不上" target="_blank">登录不上</a><a href="/tag/kaiqiyuanchengfangwen/" title="开启远程访问" target="_blank">开启远程访问</a></div> </div> </div> </div>   <div class="row row-sm"> <div class="col-sm-12 col-md-12 col-lg-12"> <div class="card">  <ins class="adsbygoogle" style="display:block" data-ad-client="ca-pub-4605373693034661" data-ad-slot="7756441254" data-ad-format="auto" data-full-width-responsive="true"></ins> <script> (adsbygoogle = window.adsbygoogle || []).push({}); </script> </div> </div> </div>  </div>  </div> </div> <footer id="footer"> <div class="container"> <div class="row hidden-xs"> <dl class="col-sm-6 site-link"> <dt>最近更新</dt><dd><a href="/win11/1005328.html" title="小米手机重装系统价格多少?专业维修服务详解" target="_blank">· 小米手机重装系统价格多少?专业维修服务详解</a><span class="text-muted pull-right">02-05</span></dd> <dd><a href="/win11/1005327.html" title="手把手教你重装电脑系统,让你的电脑焕然一新!" target="_blank">· 手把手教你重装电脑系统,让你的电脑焕然一新!</a><span class="text-muted pull-right">02-05</span></dd> <dd><a href="/win11/1005326.html" title="教你一步步重装XP系统,让你的电脑重获新生" target="_blank">· 教你一步步重装XP系统,让你的电脑重获新生</a><span class="text-muted pull-right">02-05</span></dd> <dd><a href="/win11/1005325.html" title="从备份到上网:一步步教你重装电脑系统" target="_blank">· 从备份到上网:一步步教你重装电脑系统</a><span class="text-muted pull-right">02-05</span></dd> <dd><a href="/win11/1005324.html" title="Sony笔记本电脑一键重装系统详细图文教程" target="_blank">· Sony笔记本电脑一键重装系统详细图文教程</a><span class="text-muted pull-right">02-05</span></dd> <dd><a href="/win11/1005323.html" title="Lenovo笔记本重装系统超详细教程，小白也能轻松上手" target="_blank">· Lenovo笔记本重装系统超详细教程，小白也能轻松...</a><span class="text-muted pull-right">02-05</span></dd> <dd><a href="/win11/1005322.html" title="联想笔记本一键重装Win10系统详细教程" target="_blank">· 联想笔记本一键重装Win10系统详细教程</a><span class="text-muted pull-right">02-05</span></dd> <dd><a href="/win11/1005321.html" title="电脑系统故障无需愁,专业维修店帮你重装旧貌换新颜" target="_blank">· 电脑系统故障无需愁,专业维修店帮你重装旧貌换新...</a><span class="text-muted pull-right">02-05</span></dd> <dd><a href="/win11/1005320.html" title="联想笔记本一键重装Win10系统图文教程，小白也能轻松搞定！" target="_blank">· 联想笔记本一键重装Win10系统图文教程，小白也能...</a><span class="text-muted pull-right">02-05</span></dd> <dd><a href="/win11/1005319.html" title="笔记本重装系统图文教程：从光盘启动一步到位" target="_blank">· 笔记本重装系统图文教程：从光盘启动一步到位</a><span class="text-muted pull-right">02-05</span></dd> </dl> <dl class="col-sm-4 site-link"> <dt>好站推荐</dt><dd> <a href="https://www.runoob.com" title="菜鸟教程(www.runoob.com)提供了编程的基础技术教程, 介绍了HTML、CSS、Javascript、Python，Java，Ruby，C，PHP , MySQL等各种编程语言的基础知识。同时本站中也提供了大量的在线实例，通过实例，您可以更好的学习编程。" target="_blank">菜鸟教程</a></dd><dd> <a href="https://www.jb51.cc" title="编程之家(www.jb51.cc)是成立于2017年面向全球中文开发者的技术内容分享平台。提供编程导航、编程问答、编程博文、编程百科、编程教程、编程工具、编程实例等开发者最需要的编程技术内容与开发工具支持，与你一起学习编程，相信编程改变未来！" target="_blank">编程之家</a></dd><dd> <a href="" title="前端之家 f2er.com 前端开发人员所需学习知识手册。" target="_blank">前端之家</a></dd></dl> <dl class="col-sm-2 site-link"> <dt>商务合作</dt> <dd><a target="_blank" href="http://wpa.qq.com/msgrd?v=3&uin=76874919&site=qq&menu=yes">联系我们</a></dd> </dl> </div> <div class="copyright"> Copyright © 2019 前端之家. 当前版本 V7.0.16<br> <span class="ml5">前端之家版权所有 <a href="https://beian.miit.gov.cn/" target="_blank" rel="nofollow">闽ICP备13020303号-10</a></span> </div> </div> </footer> <script type="text/javascript" src="/js/base.js"></script> </body> </html>