document.write("<div class=\"item\">    <div class=\"title\"><a href=\"http://www.itpow.com/c/803.asp\" target=\"_blank\"><span class=\"key\">用</span> <span class=\"key\">sp_executesql</span> <span class=\"key\">解决</span><span class=\"key\">字段</span><span class=\"key\">名</span>、<span class=\"key\">表名不</span><span class=\"key\">能用</span><span class=\"key\">变量</span>的<span class=\"key\">问题</span></a></div>    <div class=\"abstract\"><span class=\"pubDate\">2006年06月13日</span> bl上述代码试图<span class=\"key\">用</span> @fld <span class=\"key\">变量</span>代替<span class=\"key\">字段</span><span class=\"key\">名</span> userName，但在实际使用中却会换错，同样在表名也无法直接<span class=\"key\">用</span><span class=\"key\">变量</span>，要<span class=\"key\">解决</span>此<span class=\"key\">问题</span>，我们可以<span class=\"key\">用</span>存储过程：<span class=\"key\">sp_executesql</span>，该存储过程可以只接</div>    <div class=\"url\"><a href=\"http://www.itpow.com/c/803.asp\" target=\"_blank\">http://www.itpow.com/c/803.asp</a></div></div><div class=\"item\">    <div class=\"title\"><a href=\"http://www.itpow.com/c/2006/10/L5U5NQYCTJ653N5J.asp\" target=\"_blank\"><span class=\"key\">sp_executesql</span></a></div>    <div class=\"abstract\"><span class=\"pubDate\">2006年10月18日</span> 据库 pubs，可以直接用于测试。更多应用与知识请参见：<span class=\"key\">用</span> <span class=\"key\">sp_executesql</span> <span class=\"key\">解决</span><span class=\"key\">字段</span><span class=\"key\">名</span>、<span class=\"key\">表名不</span><span class=\"key\">能用</span><span class=\"key\">变量</span>的<span class=\"key\">问题</span>执行存储过程时到底要不要加 execT-SQL 字符串前加 </div>    <div class=\"url\"><a href=\"http://www.itpow.com/c/2006/10/L5U5NQYCTJ653N5J.asp\" target=\"_blank\">http://www.itpow.com/c/2006/10/L5U5NQYCTJ653N5J.asp</a></div></div>")