Õâ¸öSQL Ôõôд - MS-SQL Server / ÒÉÄÑÎÊÌâ
ÏÖÔÚÓÐÒ»¸ö±í´ó¸Å½á¹¹ÈçÏ£º ÉÌÆ·±àºÅ ÉÌÆ·Ãû ·ÖÀàÒ» ·ÖÀà2 ·ÖÀàÈý ·ÖÀàËÄ ·ÖÀà5 Èç¹û£º ·ÖÀàÒ» ·ÖÀà2 ·ÖÀàÈý ·ÖÀàËÄ ·ÖÀà5 ÕâÎå¸ö×Ö¶ÎÒ»ÑùµÄ»° È¡ ÉÌÆ·±àºÅ×îСµÄ¼Ç¼ ÎÊÎʸÃÔõôд£¿
SQL code: SELECT * from TB AS T WHERE NOT EXISTS(SELECT * from TB WHERE ÉÌÆ·±àºÅ<T.ÉÌÆ·±àºÅ AND ·ÖÀàÒ»=T.·ÖÀàÒ» AND ·ÖÀà2=T.·ÖÀà2 AND ·ÖÀàÈý=T.·ÖÀàÈý AND ·ÖÀàËÄ=T.·ÖÀàËÄ AND ·ÖÀà5=T.·ÖÀà5 ) ÎÒÊÔÊÔÒýÓà ÏÖÔÚÓÐÒ»¸ö±í´ó¸Å½á¹¹ÈçÏ£º ÉÌÆ·±àºÅ ÉÌÆ·Ãû ·ÖÀàÒ» ·ÖÀà2 ·ÖÀàÈý ·ÖÀàËÄ ·ÖÀà5 Èç¹û£º ·ÖÀàÒ» ·ÖÀà2 ·ÖÀàÈý ·ÖÀàËÄ ·ÖÀà5 ÕâÎå¸ö×Ö¶ÎÒ»ÑùµÄ»° È¡ ÉÌÆ·±àºÅ×îСµÄ¼Ç¼ ÎÊÎʸÃÔõôд£¿ ºÃÓÃ
Ïà¹ØÎÊ´ð£º
Ö´ÐеÄ˳Ðò£º 1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã© Ñ¡ÔñºÃÎļþºó µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏ 2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql 3 ......
ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ ÀýÈç£ ......
¿ÉÄÜÒòΪ¹¤×÷µÄÔÒò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......
sqlµÄÈí¼þÔÚÄÄÀï¿ÉÒÔϰ¡£¡ÔÚÍøÉÏÕÒÁËÂù¶à¶¼Óò»Á˰¡ Ëæ±ã¸ãÒ»D°æ°É£¬ ѸÀ×µÚÒ»¸ö¾Í¿ÉÒÔÓà 2000,2005¶¼ÕâÑù http://119.147.41.16/down?cid=0698C2D64D7D637D90A6D2482298E6717D4F15CD&t=2&fmt=-1 ......
1¡£ÔõÑùʹxp_cmdshellÄÜÍêÕûÊä³ö³¬¹ý255¸ö×Ö·ûµÄ×Ö·û´®¡£ 2¡£select ʱ£¬¼ìË÷ËÙ¶ÈÊÇÓëfromºóµÄ TABLE˳ÐòÓйأ¬»¹ÊÇÓëwhereÌõ¼þµÄ˳ÐòÓйØ(TABLEÊý¾Ý¶àÉÙ ) ÔÚϵͳÊôÐÔÉ趨ÀïÓиöÑ¡Ïî,¿ÉÒÔÐ޸ĵ¥×Ö¶ÎÊä³ö×ÖÊýÏÞÖÆ. ......