Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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


Ïà¹ØÎÊ´ð£º

MSSqlÊý¾Ý¿â±»¹ÒÂí

ÏÖÓÐÒ»¸öASP+mssqlµÄÍøÕ¾£¬±»¹ÒÂíÁË£¬½«ÀïÃæÒ»¸ö±íÖеÄntext×ֶιÒÂí¹ÒÂí£¬¡°<script src=http://ľÂíµØÖ·></script>¡±,µÄ·½Ê½ÊÇ£¬²»¶ÏµØÐ޸ĸÃ×ֶεÄÖµ£¬Ö±½Ó¼ÓÔÚ×îºóµÄ£¬Ê±¼ä³¤ÁË£¬¿ÉÒÔ¿´µ½¸Ã×Ö¶ÎÖÐÓÐ ......

150·ÖÇóvbscriptÖÐÅжÏmssqlÓï·¨´íÎó

ÔÚvbscriptÖв»ÓÃon error resume nextÈçºÎÅжÏmssqlÓï·¨´íÎó£¡
TRY CATCH?


»òÕßʹÓÃÁ÷³Ì¿ØÖÆÓï¾ä
if 
else


²»ÓÃon error ÓÃÄǸöÎҾͲ»ÐèÒªÔÚÕâÀïÑ°ÕÒ´ð°¸

ÒýÓÃ
²»ÓÃon error ÓÃÄǸöÎҾͲ»Ðè ......

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

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

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

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


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

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

mssql ¹ØÓÚwhereÓï¾äµÄλÖÃ

ÀýÈ磺select a.* from (select id,code from b left join c on b.id=c.id)a where id=1
ÕâÀïµÄwhere ÔÚÖ´ÐеÄʱºò£¬ where »áÓÅ»¯ÊÇ·ñ½øÈ뵽СÀ¨ºÅÀïÃæÖ´ÐÐ?????
SQL code:
select id,code from b left join ......

MSSQL´æ´¢Êý¾ÝÎÊÌâ

ÎÒÓõÄÊÇrealÊý¾ÝÀàÐÍ£¬µ«ÊǴ洢СÓÚ1µÄÊýʱǰÃæµÄ0ûÓÐÁË£¬¸ÃÔõô½â¾ö£¬±ÈÈ磺ÎÒÏë´æ´¢0.1£¬ÔÚÊý¾Ý¿âÀïÖ»ÓС°.1¡±,0ûÓÐÁË£¬ÒªÔõôÉèÖ㬻òÕßÊý¾ÝÀàÐÍÊDz»ÊÇÒª»»Ò»ÖÖ ??
decimal(9,1)

Õâ¸öòËÆÓëÀàÐÍÎÞ¹Ø
Óë²Ù ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ