Fri, 22 Jan 2010 06:34:00 GMTCSDN博客聚合服务http://blog.csdn.net/blogrss.aspx?username=lemonghttp://blog.csdn.net/lemong/archive/2010/01/22/5224286.aspx<br /><br />1. 建立公共类库，其中增加WCF引用，会自动生成 app.config，其中有自动生成的WCF服务客户端调用配置<br /><br /><img src="http://www1.feedsky.com/t1/324350903/lemong/csdn.net/s.gif?r=http://blog.csdn.net/lemong/archive/2010/01/22/5224286.aspx" border="0" height="0" width="0" style="position:absolute" /><p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/lemong/324350903/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/lemong/324350903/art01.gif" onerror="this.style.display='none'" /></a></p>Fri, 22 Jan 2010 14:34:00 +0800李明http://blog.csdn.net/lemong/archive/2010/01/22/5224286.aspx李明http://blog.csdn.net/lemong/archive/2010/01/22/5224286.aspxhttp://blog.csdn.net/lemong/feed.aspxcsdn.net/lemong/~1162680/324350903/1162663http://blog.csdn.net/lemong/archive/2010/01/22/5224216.aspx<br /><br />问题描述：<br /><br />1.客户端JS发起，通过AJAX传输到服务端一个长文本（含中文字符），然后调用存储过程（参数类型 varchar(max)），写入目标表（对应字段类型varchar(max)）<br /><br />3.通过该应用外网地址访问，个别数据导致错误（传入的表格格式数据流(TDS)远程过程调用(RPC)协议流不正确。参数 4 ("@content"): 数据类型 0xA7 的数据长度或元数据长度无效）<br /><br />3.通过该应用内网地址访问同一个数据，则一切正常<br /><br />解决方法：<br />更改该存储过程参数类型和对应目标表字段类型为 nvarchar(max) 类型，问题解决<br /><br />分析：<br />1.疑似问题在于AjaxPro客户端-服务端交互部分，而且内外网同样的操作有不同结果，不知道是否和IE设置部分有关联<br />2.对于SQL2008数据库，对于中文字符内容，nvarchar字段仍然是最佳选择<br /><br />结论：<br />问题比较妖异，具体原因不明，大<img src="http://www1.feedsky.com/t1/324349058/lemong/csdn.net/s.gif?r=http://blog.csdn.net/lemong/archive/2010/01/22/5224216.aspx" border="0" height="0" width="0" style="position:absolute" /><p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/lemong/324349058/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/lemong/324349058/art01.gif" onerror="this.style.display='none'" /></a></p>Fri, 22 Jan 2010 14:10:00 +0800李明http://blog.csdn.net/lemong/archive/2010/01/22/5224216.aspx李明http://blog.csdn.net/lemong/archive/2010/01/22/5224216.aspxhttp://blog.csdn.net/lemong/feed.aspxcsdn.net/lemong/~1162680/324349058/1162663http://blog.csdn.net/lemong/archive/2009/12/29/5099190.aspxC# 堆 栈 内存管理<img src="http://www1.feedsky.com/t1/324349059/lemong/csdn.net/s.gif?r=http://blog.csdn.net/lemong/archive/2009/12/29/5099190.aspx" border="0" height="0" width="0" style="position:absolute" /><p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/lemong/324349059/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/lemong/324349059/art01.gif" onerror="this.style.display='none'" /></a></p>Tue, 29 Dec 2009 15:34:00 +0800李明http://blog.csdn.net/lemong/archive/2009/12/29/5099190.aspx李明http://blog.csdn.net/lemong/archive/2009/12/29/5099190.aspxhttp://blog.csdn.net/lemong/feed.aspxcsdn.net/lemong/~1162680/324349059/1162663http://blog.csdn.net/lemong/archive/2009/11/24/4864805.aspxC# Cookie访问<img src="http://www1.feedsky.com/t1/324349060/lemong/csdn.net/s.gif?r=http://blog.csdn.net/lemong/archive/2009/11/24/4864805.aspx" border="0" height="0" width="0" style="position:absolute" /><p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/lemong/324349060/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/lemong/324349060/art01.gif" onerror="this.style.display='none'" /></a></p>Tue, 24 Nov 2009 16:17:00 +0800李明http://blog.csdn.net/lemong/archive/2009/11/24/4864805.aspx李明http://blog.csdn.net/lemong/archive/2009/11/24/4864805.aspxhttp://blog.csdn.net/lemong/feed.aspxcsdn.net/lemong/~1162680/324349060/1162663http://blog.csdn.net/lemong/archive/2009/11/24/4864614.aspxSql Server 2008 导出数据为Sql脚本<img src="http://www1.feedsky.com/t1/324349061/lemong/csdn.net/s.gif?r=http://blog.csdn.net/lemong/archive/2009/11/24/4864614.aspx" border="0" height="0" width="0" style="position:absolute" /><p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/lemong/324349061/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/lemong/324349061/art01.gif" onerror="this.style.display='none'" /></a></p>Tue, 24 Nov 2009 15:57:00 +0800李明http://blog.csdn.net/lemong/archive/2009/11/24/4864614.aspx李明http://blog.csdn.net/lemong/archive/2009/11/24/4864614.aspxhttp://blog.csdn.net/lemong/feed.aspxcsdn.net/lemong/~1162680/324349061/1162663http://blog.csdn.net/lemong/archive/2009/09/29/4616806.aspxdll.refresh 类库项目应用 发布<img src="http://www1.feedsky.com/t1/324349062/lemong/csdn.net/s.gif?r=http://blog.csdn.net/lemong/archive/2009/09/29/4616806.aspx" border="0" height="0" width="0" style="position:absolute" /><p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/lemong/324349062/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/lemong/324349062/art01.gif" onerror="this.style.display='none'" /></a></p>Tue, 29 Sep 2009 13:09:00 +0800李明http://blog.csdn.net/lemong/archive/2009/09/29/4616806.aspx李明http://blog.csdn.net/lemong/archive/2009/09/29/4616806.aspxhttp://blog.csdn.net/lemong/feed.aspxcsdn.net/lemong/~1162680/324349062/1162663http://blog.csdn.net/lemong/archive/2009/09/18/4566288.aspxsql server 中charindex/patindex/like 的比较<img src="http://www1.feedsky.com/t1/324349063/lemong/csdn.net/s.gif?r=http://blog.csdn.net/lemong/archive/2009/09/18/4566288.aspx" border="0" height="0" width="0" style="position:absolute" /><p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/lemong/324349063/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/lemong/324349063/art01.gif" onerror="this.style.display='none'" /></a></p>Fri, 18 Sep 2009 13:27:00 +0800李明http://blog.csdn.net/lemong/archive/2009/09/18/4566288.aspx李明http://blog.csdn.net/lemong/archive/2009/09/18/4566288.aspxhttp://blog.csdn.net/lemong/feed.aspxcsdn.net/lemong/~1162680/324349063/1162663http://blog.csdn.net/lemong/archive/2009/09/18/4566206.aspx如何应用 updatetext 对sql server 中ntext字段批量替换<img src="http://www1.feedsky.com/t1/324349064/lemong/csdn.net/s.gif?r=http://blog.csdn.net/lemong/archive/2009/09/18/4566206.aspx" border="0" height="0" width="0" style="position:absolute" /><p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/lemong/324349064/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/lemong/324349064/art01.gif" onerror="this.style.display='none'" /></a></p>Fri, 18 Sep 2009 13:05:00 +0800李明http://blog.csdn.net/lemong/archive/2009/09/18/4566206.aspx李明http://blog.csdn.net/lemong/archive/2009/09/18/4566206.aspxhttp://blog.csdn.net/lemong/feed.aspxcsdn.net/lemong/~1162680/324349064/1162663http://blog.csdn.net/lemong/archive/2008/08/18/2790082.aspx失业 计划<p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/lemong/324349065/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/lemong/324349065/art01.gif" onerror="this.style.display='none'" /></a></p>Mon, 18 Aug 2008 15:31:00 +0800lemonghttp://blog.csdn.net/lemong/archive/2008/08/18/2790082.aspxlemonghttp://blog.csdn.net/lemong/archive/2008/08/18/2790082.aspxhttp://blog.csdn.net/lemong/feed.aspxcsdn.net/lemong/~1162680/324349065/1162663http://blog.csdn.net/lemong/archive/2008/08/07/2782914.aspxSQL2005，大数据量，检索，分页，查询<p class="fswww1"><a href="http://www1.feedsky.com/r/l/csdn.net/lemong/324349066/art01.html" target="_blank"><img border="0" ismap="ismap" src="http://www1.feedsky.com/r/i/csdn.net/lemong/324349066/art01.gif" onerror="this.style.display='none'" /></a></p>Thu, 07 Aug 2008 15:46:00 +0800李明http://blog.csdn.net/lemong/archive/2008/08/07/2782914.aspx李明http://blog.csdn.net/lemong/archive/2008/08/07/2782914.aspxhttp://blog.csdn.net/lemong/feed.aspxcsdn.net/lemong/~1162680/324349066/1162663