sql 2000 °²×°ÎÊÌâ¡£
°²×°²»ÉÏ£¬ ÎÒ¹À¼ÆÊÇÒòΪÎÒÒÔǰװ¹ý¡£ ÇëÎÊ ÎÒÔõôÄܰѵçÄÔÉϵÄsql 2000Íê³Éɾ³ý£¿
ÓÅ»¯´óʦÇåÀíÒ»ÏÂ×¢²á±íÒýÓà ÓÅ»¯´óʦÇåÀíÒ»ÏÂ×¢²á±í ÔõôŪ£¿£¿£¿£¿ ÏÈÔÚ¿ØÖÆÃæ°å->Ìí¼Ó»òɾ³ý³ÌÐò->Ñ¡Ôñ¹ØÓÚMicrosoft SQL Server 2000µÄÈ«²¿ÄÚÈÝ¡£ ÔÙɾ³ýC:\Program Files\Microsoft SQL ServerÕâ¸öĿ¼¡¾Ã»Óа²×°2005»òÕß2008µÄÇé¿öÏ¡¿ ¿ÉÒÔÔÚ¿ØÖÆÃæ°åɾ³ý È»ºóÔÙÓ󬼶ÍÃ×Ó»òÕßÓÅ»¯´óʦÀ´ÇåÀí×¢²á±í ÎÒ°²×°Ê±£¬ µ¯³öµÄÌáʾÐÅÏ¢ÊÇ£º ÒÔǰµÄij¸ö³ÌÐòÒÑÔÚ°²×°¼ÆËã»úÉÏ´´½¨¹ÒÆðµÄÎļþ²Ù×÷¡£ÔËÐа²×°³ÌÐò֮ǰ±ØÐëÖØÐÂÆô¶¯¼ÆËã»ú¡£ ÎÒÓ¦¸ÃÔõôŪ£¿£¿£¿ÒýÓà ÎÒ°²×°Ê±£¬ µ¯³öµÄÌáʾÐÅÏ¢ÊÇ£º ÒÔǰµÄij¸ö³ÌÐòÒÑÔÚ°²×°¼ÆËã»úÉÏ´´½¨¹ÒÆðµÄÎļþ²Ù×÷¡£ÔËÐа²×°³ÌÐò֮ǰ±ØÐëÖØÐÂÆô¶¯¼ÆËã»ú¡£ ÎÒÓ¦¸ÃÔõôŪ£¿£¿£¿ ɾ³ý×¢²á±íPENDFILE... ²»ÖªµÀÕ¦´òµÄ,ÔÚLOCAL×¢²á±íÏ ÎÒÖØÆôÁË¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£ÒýÓà ÎÒ°²×°Ê±£¬ µ¯³öµÄÌáʾÐÅÏ¢ÊÇ£º ÒÔǰµÄij¸ö³ÌÐòÒÑÔÚ°²×°¼ÆËã»úÉÏ´´½¨¹ÒÆðµÄÎļþ²Ù×÷¡£ÔËÐа²×°³ÌÐò֮ǰ±ØÐëÖØÐÂÆô¶¯¼ÆËã»ú¡£ ÎÒÓ¦¸ÃÔõôŪ£¿£¿£¿ £¿£¿£¿ ʲôÒâ˼£¿ thanks¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£ SQL77 ÊÇÌáʾ³ÌÐò¹ÒÆð£¿ÓÃÕâ¸öÊÔÊÔ¡£¡£¡£ HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session ManagerÖÐÕÒµ½PendingFileRenameOperationsÏîÄ¿£¬²¢
Ïà¹ØÎÊ´ð£º
Ö´ÐеÄ˳Ðò£º 1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã© Ñ¡ÔñºÃÎļþºó µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏ 2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql 3 ......
ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ ÀýÈç£ ......
ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql declare TYPE test_rec IS record( code varchar(10), name varchar(30) ); v_book test_rec; ......
¸Õ¸Õ½Ó´¥MySQL,²»ÖªµÀ¸ÃÈçºÎÈ¥²é¿´Êý¾Ý£¬²åÈëÊý¾Ý£¬´´½¨Êý¾Ý¿â¡¢±í£¬ÓÃÄÄΪǰ±²ÄÜÖ¸½ÌÒ»¶þ£¿ MySQL 5.1²Î¿¼ÊÖ²á ÒýÓà ÐÖµÜÄã»á½áÌùÂ𣿠mysql ²Î¿¼ÊÖ²á baidu MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc ......
µÚÒ»¾ä: select ht.gfdm,gfdm.gfmc,gfdm.lb ,sum(jh.htdj*jh.htsl)as je from ht left join gfdm on ht.gfdm=gfdm.gfdm join jh on ht.htbh=jh.hth and ht.htbh not like'del%' and ht. ......