ÇóÒ»SQLÓï¾äµÄת»»
ÏÖÔÚÓÐÒÔÏÂSQLÓï¾ä£º
<stl:sqlContents connectionStringname="connectionStringname">
<stl:queryString>
SELECT TOP 30 image, ('http://www.postcha.com/xiaohua/xiaohua_' + cast(id as varchar) + '.html') AS xiaohua_Url from au_xiaohua
ORDER BY newid()
</stl:queryString>
<ul id="rarclist" class="arclist">
<li><a href="{Sql.xiaohua_Url}" target="_blank"><img src="{sql.image}"></a></li>
</ul>
</stl:sqlContents>
µ«ÊÇÏÖÔÚÓÐÒ»¸öÎÊÌ⣬¾ÍÊÇÔÚimage×Ö¶ÎÖдæµÄÊÇ@/upload/2010/postcha.jpgÕâÑùµÄÖµ£¬¾ÍÊÇ´øÓÐ@Õâ¸ö×Ö·û¡£ÒòΪ³ÌÐòµÄĬÈϵ÷ÓÃͼƬÊÇ<stl:image>±êÇ©£¬¿ÉÒÔ½«@ת»¯Îªµ±Ç°Õ¾µãµÄÓòÃû£¬µ«ÊDz»Ö§³ÖËæ»úÏÔʾ¡£
ÉÏÃæÉú³ÉµÄ´úÂëÊÇ<a href="'http://www.postcha.com/xiaohua/xiaohua_1.html"><img src="@/upload/2010/postcha.jpg"></a>£¬Õâ¸ö@ûÓÐת»»µô£¬µ¼ÖÂͼƬ²»ÄÜÏÔʾ¡£
ËùÒÔ¾ÍÏëÖ±½ÓÓÃsqlÓï¾äÀ´²éѯ£¬µ«ÊÇÏÖÔÚÓÖÓöµ½Õâ¸ö@ת»»µÄÎÊÌ⣬ÄĸöSQL¸ßÊÖ°ïæ¿´¿´¡£
SQL code:
replace(col,@,'')
СµÜÓÞÃÁ£¬Õâ¸ö²ÎÊýÒª·ÅÔÚÄĸöλÖ㿸Ðл¡£
SQL code:
SELECT TOP 30 image, REPLACE(('http://www.postcha.com/xiao
Ïà¹ØÎÊ´ð£º
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
protected void btnLogin_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection("Server = (local);user id = sa;pwd = 1;database = Login");
&nb ......
СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿
3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......
µÚÒ»¾ä:
select ht.gfdm,gfdm.gfmc,gfdm.lb ,sum(jh.htdj*jh.htsl)as je
from ht left join gfdm on ht.gfdm=gfdm.gfdm
join jh on ht.htbh=jh.hth
and ht.htbh not like'del%' and ht. ......