Win7ϰ²×°SQL Server2005
ÔÚWin7ϰ²×°SQL2005¿ª·¢°æ£¬°²×°SQL Native ClientʱÌáʾ°²×°Öжϣ¬Ã»ÓÐÔÚÒ⣬ȻºóÔÚ°²×°SQL ServerʱÓÖÌáʾ“[Microsoft][SQL Native Client]¿Í»§¶Ë²»Ö§³Ö¼ÓÃÜ.SQL Server °²×°³ÌÐòÎÞ·¨Á¬½Óµ½Êý¾Ý¿â·þÎñ½øÐзþÎñÆ÷ÅäÖÃ.”Ð¶ÔØSQL Native ClientÖØÐ°²×°£¬»¹ÊÇÖжϣ¬ÐÞ¸´£¬Ò²Öжϣ¬ÔÙÐ¶ÔØ£¬ÇåÀí×¢²á±í£¬ÖØ×°»¹ÊÇÕâ¸öÎÊÌ⣬ºóÀ´ÓÃħ·½½øÐÐÈí¼þÐ¶ÔØ¡¢ÐÞ¸´£¬¾¹È»È´³É¹¦ÁË¡£¹ÖÊÂ~~
ÔÙ°²×°SQL Server ¾ÍûÓÐÌáʾÁË£¬°²×°³É¹¦¡£È»ºó´òÉÏSP3µÄ²¹¶¡£¬²¹¶¡¼´½«½áÊøÊ±»áÌáʾÓû§½øÐÐȨÏÞÉèÖá£
¸½¼ÓÊý¾Ý¿â£¬OK£¡
Ïà¹ØÎĵµ£º
1¡¢SELECT ²éѯÓï¾äºÍÌõ¼þÓï¾ä
SELECT ²éѯ×Ö¶Î from ±íÃû WHERE Ìõ¼þ
²éѯ×ֶΣº¿ÉÒÔʹÓÃͨÅä·û* ¡¢×Ö¶ÎÃû¡¢×ֶαðÃû
±íÃû£º Êý¾Ý¿â.±íÃû £¬±íÃû
³£ÓÃÌõ¼þ£º = µÈÓÚ ¡¢<>²»µÈÓÚ¡¢in °üº¬ ¡¢ not in ²»°üº¬¡¢ like Æ¥Åä
BETWEEN ÔÚ·¶Î§ ¡¢ not BETWEE ......
/***************************************************
×÷Õߣºherowang(ÈÃÄãÍû¼ûÓ°×ÓµÄǽ£©
ÈÕÆÚ£º2009.12.19
×¢£º ×ªÔØÇë±£Áô´ËÐÅÏ¢
&nb ......
ÎÒÃÇÒª×öµ½²»µ«»áдSQL,»¹Òª×öµ½Ð´³öÐÔÄÜÓÅÁ¼µÄSQL,ÒÔÏÂΪ±ÊÕßѧϰ¡¢ÕªÂ¼¡¢²¢»ã×ܲ¿·Ö×ÊÁÏÓë´ó¼Ò·ÖÏí£¡
£¨1£©Ñ¡Ôñ×îÓÐЧÂʵıíÃû˳Ðò(Ö»ÔÚ»ùÓÚ¹æÔòµÄÓÅ»¯Æ÷ÖÐÓÐЧ)£º
orACLEµÄ½âÎöÆ÷°´ÕÕ´ÓÓÒµ½×óµÄ˳Ðò´¦Àífrom×Ó¾äÖеıíÃû£¬from×Ó¾äÖÐдÔÚ×îºóµÄ±í(»ù´¡±í driving table)½«±»×îÏÈ´¦Àí£¬ÔÚfrom×Ó¾äÖаüº¬¶à¸ö±íµÄÇé¿öÏ ......
oracleÊý¾Ý¿âÖÐsql»ù´¡
×÷ÕߣºØýÃû תÌù×Ô£º±¾Õ¾Ô´´ ä¯ÀÀ´ÎÊý£º21 ÎÄÕ¼È룺admin
Ò»¡¢¹ØÏµÊý¾Ý¿âµÄһЩ¸ÅÄî
¡¡¡¡
¡¡¡¡1¡¢Ö÷¼üµÄÖµÒ»°ã²»¿ÉÒԸıä
¡¡¡¡
¡¡¡¡2¡¢Íâ¼ü£ºÖ¸ÏòÁíÒ»¸ö±í»ò±¾±íµÄÖ÷¼ü»òΨһ¼üµÄ×ֶΡ£Íâ¼üµÄÖµÒ»¶¨ÒªºÍijһÖ÷¼üÏàͬ ......
¶þ£ºÓÐЧµÄÓ¦ÓÃÉè¼Æ
ÎÒÃÇͨ³£½«×î³£ÓõÄÓ¦Ó÷ÖΪ2ÖÖÀàÐÍ£ºÁª»úÊÂÎñ´¦ÀíÀàÐÍ(OLTP)£¬¾ö²ßÖ§³Öϵͳ(DSS)¡£
Áª»úÊÂÎñ´¦Àí(OLTP)
¸ÃÀàÐ͵ÄÓ¦ÓÃÊǸßÍÌÍÂÁ¿£¬²åÈë¡¢¸üС¢É¾³ý²Ù×÷±È½Ï¶àµÄϵͳ£¬ÕâЩϵͳÒÔ²»¶ÏÔö³¤µÄ´óÈÝÁ¿Êý¾ÝÎªÌØÕ÷£¬ËüÃÇÌṩ¸ø³É°ÙÓû§Í¬Ê±´æÈ¡£¬µäÐ͵ÄOLTPϵͳÊǶ©Æ±ÏµÍ³£¬ÒøÐеÄÒµÎñϵͳ£¬¶©µ¥ÏµÍ³¡£OT ......