Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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ССµÄÒÉÎÊ - .NET¼¼Êõ / C#

¿ÉÄÜÒòΪ¹¤×÷µÄÔ­Òò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......

SQLÈçºÎÓÅ»¯ÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

½ñÌì×öÁËÒ»¸ö´æ´¢¹ý³Ì   »·¾³ÊÇSQL2000Êý¾Ý¿â  
´óÖÂÈçÏÂ
½¨Á¢ÁÙʱ±í
¶¨ÒåÔ±¹¤Óαê
        Ñ­»·Ô±¹¤£¨ÊôÓÚ1¸ö¹«Ë¾)  
        ......

ÇóÒ»sqlÓï¾ä - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle)
ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄǰ2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ