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

db2ºÍMSSQLµÄÇø±ð

db2ºÍMSSQLµÄÇø±ð(ÓÈÆäÊÇSQLÓï¾ä·½ÃæµÄÓï·¨£¬»¹ÇëÏêϸµãлл)
»°ÌâÌ«´ó£¬½¨ÒéÏÈÔÚÍøÉÏ×Ô¼ºËÑË÷һϡ£ Äã¿ÉÒÔÌù³ö¾ßÌåµÄijһµãÈôó¼ÒÀ´ÌÖÂÛ¡£

liuzhimsn (liuzhimsn)
  '½ØÖÁ2010-03-31 15:46:29 Óû§½áÌûÂÊ0.00%

µ±ÄúµÄÎÊÌâµÃµ½½â´ðºóÇ뼰ʱ½áÌù.
http://topic.csdn.net/u/20090501/15/7548d251-aec2-4975-a9bf-ca09a5551ba5.html

ºÃµÄлл°¡


DB2Ö÷ÒªÓ¦ÓÃÓÚ´óÐÍÓ¦ÓÃϵͳ£¬¾ßÓнϺõĿÉÉìËõÐÔ£¬¿ÉÖ§³Ö´Ó´óÐÍ»úµ½µ¥Óû§»·¾³£¬Ó¦ÓÃÓÚOS/2¡¢WindowsµÈƽ̨Ï¡£ DB2ÌṩÁ˸߲ã´ÎµÄÊý¾ÝÀûÓÃÐÔ¡¢ÍêÕûÐÔ¡¢°²È«ÐÔ¡¢¿É»Ö¸´ÐÔ£¬ÒÔ¼°Ð¡¹æÄ£µ½´ó¹æÄ£Ó¦ÓóÌÐòµÄÖ´ÐÐÄÜÁ¦£¬¾ßÓÐÓëÆ½Ì¨Î޹صĻù±¾¹¦ÄܺÍSQLÃüÁî¡£DB2²ÉÓÃÁËÊý¾Ý·Ö¼¶¼¼Êõ£¬Äܹ»Ê¹´óÐÍ»úÊý¾ÝºÜ·½±ãµØÏÂÔØµ½LANÊý¾Ý¿â·þÎñÆ÷£¬Ê¹µÃ¿Í»§»ú/·þÎñÆ÷Óû§ºÍ»ùÓÚLANµÄÓ¦ÓóÌÐò¿ÉÒÔ·ÃÎÊ´óÐÍ»úÊý¾Ý£¬²¢Ê¹Êý¾Ý¿â±¾µØ»¯¼°Ô¶³ÌÁ¬½Ó͸Ã÷»¯¡£ ËüÒÔÓµÓÐÒ»¸ö·Ç³£Í걸µÄ²éѯÓÅ»¯Æ÷¶øÖø³Æ£¬ÆäÍⲿÁ¬½Ó¸ÄÉÆÁ˲éѯÐÔÄÜ£¬²¢Ö§³Ö¶àÈÎÎñ²¢Ðвéѯ¡£ DB2¾ßÓкܺõÄÍøÂçÖ§³ÖÄÜÁ¦£¬Ã¿¸ö×Óϵͳ¿ÉÒÔÁ¬½ÓÊ®¼¸Íò¸ö·Ö²¼Ê½Óû§£¬¿Éͬʱ¼¤»îÉÏǧ¸ö»î¶¯Ị̈߳¬¶Ô´óÐÍ·Ö²¼Ê½Ó¦ÓÃϵͳÓÈΪÊÊÓá£
MSÖ¸µÄÊÇ΢ÈíMicrosoft,SQLÊǽṹ»¯²éѯÓïÑÔ.½áºÏÆðÀ´¾ÍÊÇ˵:MS SQLÊÇָ΢ÈíµÄSQL ServerÊý¾Ý¿â·þÎñÆ÷£¬ËüÊÇÒ»¸öÊý¾Ý¿âƽ̨£¬ÌṩÊý¾Ý¿âµÄ´Ó·þÎñÆ÷µ½Öն˵ÄÍêÕûµÄ½â¾ö·½°¸£¬ÆäÖÐÊý¾Ý¿â·þÎñÆ÷²¿·Ö£¬ÊÇÒ»¸öÊý¾Ý¿â¹ÜÀíϵͳ£¬ÓÃÓÚ½¨Á¢¡¢Ê¹ÓúÍά»¤Êý¾Ý¿â¡£
 SQL ServerÒ»¿ªÊ¼²¢²»ÊÇ΢Èí×Ô¼ºÑз¢µÄ²úÆ·£¬¶øÊǵ±Ê±ÎªÁËÒªºÍIBM¾ºÕùʱ£¬ÓëSybaseºÏ×÷Ëù²úÉúµÄ£¬Æä×îÔçµÄ·¢Õ¹ÕßÊÇSybase£¬Í¬Ê±Î¢ÈíÒ²ºÍSybaseºÏ×÷¹ý SQL Server 4.2°æ±¾µÄÑз¢£¬Î¢ÈíÒཫSQL Server 4.2ÒÆÖ²µ½Windows NT£¨µ±Ê±Îª3.1°æ£©£¬ÔÚÓëSybaseÖÕÖ¹ºÏ×÷¹ØÏµºó£¬×ÔÁ¦¿ª·¢³öSQ


Ïà¹ØÎÊ´ð£º

¹ØÓÚACCESSºÍMSSQLµÄÎÊÌâ - Web ¿ª·¢ / ASP

ÓÐÒ»¸öÊý¾Ý¿âÀïÖ»ÓÐ2WÌõÊý¾Ý²»µ½£¬È´ÓÐ500MÄÇô´ó,Ôõô»ØÊ°¡£¿ÊÇACCESSµÄÊý¾Ý¿â¡£ºóÀ´ÎÒ°ÑACCESSµ¼Èëµ½MSSQLÖУ¬Ò²Õ¼ÓÃÁË500M×óÓҵĿռ䣬Èç¹ûѹËõÊý¾Ý¿âÄØ£¿Çë¸ßÊÖÖ¸µã
ѹËõÊý¾Ý¿â£¿ÄÜ×öµ½Ã´...
ÆÚ´ý¸ßÈËÖ¸µã ÎÒ ......

ÈçºÎÓÃasp²åÈëÊýÖµµ½ mssql Varbinary(16)×Ö¶Î

ÒѾ­¼ÜÉèºÃÁËÓÎÏ·£¬ÄÜÔËÐÐÁË£¡¡¾ÓÎÏ·²»ÊÇÎÒ×öµÄËùÒÔÀïÃæµÄÔ´ÂëʲôµÄ¶¼²»´óÇå³þ¡¿ÓÎϷʹÓõÄÊý¾Ý¿âÊÇMSSQLµÄ¡£
ÏëÓÃÍøÕ¾ÊµÏÖÔÚÍøÒ³ÖÐ×¢²áÕ˺ÅÀ´²åÈëµ½Ö¸¶¨µÄMSsqlÓû§±íÖÐ! ÒÔ±ã´ïµ½ÔÚÍøÕ¾×¢²áÁËÕ˺źóÄÜÔÚÓÎÏ·ÀïÃæ ......

MSSQLÔõô»ñÈ¡Êý¾Ý¿âÀúÊ·²éѯ×Ü´ÎÊý

ÈçÌ⣬MYSQLÓÖÔõô»ñÈ¡£¿
ÈçÌâ

Õâ¸ö¹À¼ÆÔÚÈÕÖ¾ÎļþÖвÅÄÜ¿´¼û°É

Õâ¸ö¹À¼ÆÔÚÈÕÖ¾ÎļþÖвÅÄÜ¿´¼û°É


ÒýÓÃ
³ý·ÇÄãÒµÎñÉÏ×ö¼Ç¼£¬·ñÔòÄãÊDz»ÄÜÖªµÀµÄ¡£ÒòΪÈÕÖ¾²»¼Ç¼selectÓï¾äÃüÁî¡£
..

ÄÇÓÐûÓÐϵͳ´ ......

MSSQLµÄsqlÓï¾ä

ÎÒÔ­À´ÊÇÓÉaccessת³ÉmssqlµÄ..Ô­À´µÄ×ÔÔö×Ô¶¯Ã»ÓÐÁË
ÎÒÔõôÓÃsqlÀ´×ª»¯ÄØ£¿£¨²»ÏëÔÚÆóÒµÃæ°å¹ÜÀíÖÐ¸Ä ±íÌ«¶à..£©
»¹ÓÐsmalldateµÄĬÈÏÖµ¸Ä³Égetdate()µÄÓï¾äÒªÔõôд..ллÁË
accessת³ÉmssqlµÄ..Ô­À´µÄ×ÔÔö×Ô¶ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ