ÎÒÓÃtestÓû§ÒÔNormal½ÇÉ«µÇ¼£¬È»ºó´´½¨Ò»¸ö±í¿Õ¼ä£¬²¢Ôڸñí¿Õ¼äÏ´´½¨Ò»¸ö±íuser¡£
Èç¹ûÎÒÓÃtestÓû§ÒÔsysdba½ÇÉ«µÇ¼£¬Ö´ÐÐselect * from user;±¨´í¡°±í»òÊÓͼ²»´æÔÚ¡±£¬Õâ¸öÊÇÔõô»ØÊÂÄØ£¿
ÐÂÊÖÇóÖú£¬¶àлָµã¡£
select * from test.user;
ÊÔÊÔ
ÒýÓÃ
ÎÒÓÃtestÓû§ÒÔNormal½ÇÉ«µÇ¼£¬È»ºó´´½¨Ò»¸ö±í¿Õ¼ä£¬²¢ÔÚ¸ ......
°²×°µÄÊÇ2.0µÄAJAX¿ò¼Ü£¬Ìí¼ÓµÄÊÇ2.0µÄAjaxControlToolkit.dllµÄÒýÓ㬿ÉÊÇÔÚÒ³ÃæÀ¿Ø¼þµÄʱºò£¬ÀÏÊdzöÏÖÕâÑùµÄ´íÎó!
Ò³Ãæ´úÂ룺
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<%@ Register Assembly="A ......
´ÓÍøÉÏÏÂÁËÒ»¸ö·ÂGoogleËÑË÷¹¦ÄܵÄAJAX£¬ÏÖÔÚ°ÑÒ»¸öÊäÈë¿ò¸Ä³ÉÁ½¸ö£¬²¿·Öº¯ÊýÒ²Çø·Ö¿ª£¬µÚÒ»¸öµ÷ÓÃûÓÐÎÊÌ⣬µ«Êǵڶþ¸öºÁÎÞ¶¯¾²£¬²»ÖªµÀÄÄÀï´íÁË£¬Çë¸÷λ¸ßÊÖ°ïæ¸ÄÕýһϡ£
htmlÒ³Ãæ£º
<script language="javascript" src="YSBD_ZX_search.js"></script>
<input name="zyxzna ......
±íA
SQL code:
autoID outDate type resultDate
1 2010-05-10 11£º12£º03 1 null
2 2010-05-10 15£º10£º03 0 null
3 2010-05-12 11£º12£º03 0 null
4 2010-05-14 11£º12£º03 ......
select case null
when '' then '1'
when null then '2' --ΪʲôûÓÐÔÚÕâ¸öλÖÃÅжϳöÀ´
else '3'
end a
select 1 a,2 b into #a
select isnull(b,0) b from #a where a=2
--bÁÐûÓÐÊý¾Ý Ó¦¸ÃÓÃʲôÀ´ÅжÏbÊǿյÄÄØ
--bÁÐûÓÐÊý¾Ý Ó¦¸ÃÓÃʲôÀ´ÅжÏbÊǿյÄÄØ
where b is null
NU ......
ÎÒÏë°ÑһЩext¿Ø¼þ¡¢±ÈÈçtextbox¡¢select¡¢¡¢Ð´Èëµ½htmlÒ³ÃæÀȻºóͨ¹ýext¸³Öµ£¬´Ó¶øÊµÏÖÔö¡¢É¾¡¢¸Ä¡¢²éµÈ²Ù×÷ÔÚÒ»¸öºóÌ¨Ò³ÃæÖнøÐУ¬
×îºÃÊÇÍêȫͨ¹ýExtÉú³É£¬·ñÔòÓÐÁË´íÎó¶¼²»Öªµ½ÄÇÈ¥ÕÒ£¬ExtËäȻǿ´ó£¬¿ÉÊÇÒòΪ¿ªÔ´ÓÐÏÞ£¬ËùÒÔ·â×°ÐÔÇ¿£¬ºÜÄѽøÐÐÔ´Âë´íÎóÐ޸ġ£¶øÇÒÔÚIEºÍ»ðºüÖеÄÏÔʾҲ²»Í¬£¬Èç¹ûÖ»Êǵ¥Î» ......