sql server2005Êý¾Ý¿â¼ÓÃÜ - MS-SQL Server / »ù´¡Àà
×öÁËÒ»¸ö¹ÜÀí³ÌÐò
ÏëÈÃÊý¾Ý¿âÓиöÃÜÂë
Ö»ÓÐÊäÈëÃÜÂë²ÅÄܽøÈëÊý¾Ý¿âÖÐ
½øÐÐÐ޸ģ¬
µÚÒ»´Î×öÊý¾Ý¿â£¬ÇëÎÊ´ó¼ÒÈçºÎ¸øÊý¾Ý¿â»òÕß
ÆäÖеıíÉèÖÃÃÜÂ룬ÒÔ·À±ðÈ˵ǽ
1Â¥µÄÄÜÏêϸЩÂð£¿
ûÓп´¶®
º¹ ²»ÊÇÓÀÉú¸çµÄÒâ˼°É
Â¥Ö÷²»±Ø×ö³ÌÐòµÄ£¬sql×Ô´ø·þÎñÆ÷½ÇÉ«ºÍÊý¾Ý¿â½ÇÉ«£¬Äã¿ÉÒÔÌí¼Ó¸öÓû§£¬ÔÚ·þÎñÆ÷½ÇÉ«ÀïÄÜ¿ØÖÆËûÃǶԱí²Ù×÷µÄȨÏÞ
Ïà¹ØÎÊ´ð£º
Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle)
ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄǰ2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......
ͨ¹ýNAME×Ö¶ÎÌõ¼þ²éѯһ¸öÊý¾Ý±í£¬¼ÙÉèÎÒÓÐ100¸öÐÕÃû£¬ÓÐÒÔÏÂÁ½¸ö·½·¨£¬
·½·¨1£º
°Ñ100¸öName ×é³ÉÒ»¸öSQLÓï¾ä£¬±ÈÈç Select * from tmp_table where Name='ÕÅÈý' or Name ='ÀîËÄ' Or ...Or Name='µÚÒ»°Ù¸öÐÕÃû'
......
Ôõô°ÑMDFÊý¾Ýתµ½MySQL£¿
ÖÁÉٵø½¼Óµ½sqlserverÉÏ
¾ßÌåÔõôŪ°¡ ÎҵıÏÒµÉè¼ÆµÄÊý¾Ý¿âÊÇ´ÓÍøÉÏdownÏÂÀ´µÄ£¿£¿
Ä㻹²»ÈçÖ±½ÓÓÃsqlserverÄØ
º¯Êý¡¢´æ´¢¹ý³Ì¶¼µÃ¸ÄÁË¡£
sqlserverûÔõôÓùý¡£Ò²Ã»Óа²× ......