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

SQLÓï¾äÎÊÌâ

SQL code:
SELECT * from users
WHERE (abNumber = @ab) AND (Pwd = @pwd) OR
(cdNumber = @cd) AND (Pwd = @pwd) OR
(DataExNumber = @data) AND (Pwd = @pwd) OR
(ddNumber = @dd) AND (Pwd = @pwd) OR
(CallCenterNumber = @call) AND (Pwd = @pwd) OR
(MsgNumber = @msg) AND (Pwd = @pwd) OR
(XunHuNumber = @xunhu) AND (Pwd = @pwd) OR
(CunChuNumber = @cun) AND (Pwd = @pwd) OR
(VirtualNumber = @vir) AND (Pwd = @pwd) OR
(VsatNumber = @vsat) AND (Pwd = @pwd)

ÔÚ±¾µØ²âÊÔ¿ÉÒÔ¸ù¾ÝÊäÈëµÄ²ÎÊý²éѯ³öÊý¾Ý£¬µ«ÊÇÉÏ´«µ½·þÎñÆ÷ºóÊäÈëÏàÓ¦²ÎÊýËü²éѯ³öÀ´µÄÊý¾Ý×ÜÊÇijһÌõ£¬ÎªÊ²Ã´°¡£¿ÓôÃÆÖУ¡£¡~
Óï¾äûÎÊÌâ..·þÎñÆ÷ÉϵÄÊý¾Ý¾ÍÊÇÖ»ÓÐÒ»Ìõ°É

·þÎñÆ÷ÉϵÄÊý¾Ý²»ÊÇÒ»Ìõ

ÔÚ·þÎñÆ÷ÉÏͨ¹ý²éѯ·ÖÎöÆ÷¶¼¿ÉÒÔ²éѯ³öÊý¾Ý£¬µ«ÊdzÌÐòÒ»ÔËÐоͲéѯ²»³öÀ´£¬³ÌÐòÊÇasp.netµÄ


ÒýÓÃ
ÔÚ·þÎñÆ÷ÉÏͨ¹ý²éѯ·ÖÎöÆ÷¶¼¿ÉÒÔ²éѯ³öÊý¾Ý£¬µ«ÊdzÌÐòÒ»ÔËÐоͲéѯ²»³öÀ´£¬³ÌÐòÊÇasp.netµÄ


ÄǾÍÊdzÌÐòÖÐÏÔʾÊý¾ÝµÄ²¿·ÖÓÐÎÊÌâ!!


µ«ÊÇÔÚ±¾µØµ÷ÊÔ¶¼ÊÇÕý³£µÄ

ÎÒµÄsqlÓï¾äÓдíû£¿

ÊÇÔÚ³ÌÐòÖÐÆ´½ÓSQLÓï¾ä£¿
¶Ïµãµ÷ÊÔ£¬×¥µ½Óï¾ä£¬²éѯ·ÖÎöÆ÷ÔËÐ


Ïà¹ØÎÊ´ð£º

sql ´æ´¢¹ý³Ì

ÎÒÒª×öÒ»¸ö¶¨µãʼþ£¬ÊÇÿÌìÍíÉÏ12µã¾Í°ÑÈý¸ö±íÀïµÄÐÅÏ¢·ÅÈëÒ»¸ö±íÀÎÒÏëÓô洢¹ý³ÌÀ´Ð´£¬ÔõÃ´Ð´ÄØ£¿£¬ÄÇλ¸ßÊÖ°ï°ïæ°É£¬·Ç³£¸Ðл£¡

Óû§ÃûÊÇΨһµÄ
±íA  ×Ö¶Î
Óû§Ãû£ºName  ,ÓÊÏ䣺Ema ......

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

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

sql ËÑË÷Óï¾ä - .NET¼¼Êõ / ASP.NET

<table style="width: 1000px"><tr>
  <td style="height: 38px; width: 35px;">
  ÐÕÃû</td>
  ......

Êý¾ÝÒÔxml¸ñʽ·µ»Ø - MS-SQL Server / Ó¦ÓÃʵÀý

´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽ
XML code:
<folder state="unchecked" label="È«²¿">
¡¡¡¡ <folder state="unchecked&qu ......

ÇóÒ»sqlÓï¾ä - MS-SQL Server / »ù´¡Àà

±í
id bh  
1 10
2 11
3 12 
4 15
5 16
6 22
7 25
8 26
9 27
10 28
½«bh°´Á¬Ðø·Ö¶Î³öÀ´·µ»Ø×Ö·û´®£º
10~12£¬15~16£¬22£¬25~28
SQL code:


declare @t tabl ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ