Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÇóÒ»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


Ïà¹ØÎÊ´ð£º

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

ASPÁ´½ÓSQLµÄ¼òµ¥µÇ½½çÃæ - .NET¼¼Êõ / ASP.NET

protected void btnLogin_Click(object sender, EventArgs e)
  {
  SqlConnection conn = new SqlConnection("Server = (local);user id = sa;pwd = 1;database = Login");
&nb ......

pl/sql - Oracle / ¿ª·¢

СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿

3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......

Á½¾äSQL²¢Ò»¾ä,ÓÐÎÊÌâ. - MS-SQL Server / »ù´¡Àà

µÚÒ»¾ä:
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. ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ