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

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ÏîÄ¿£¬²¢


Ïà¹ØÎÊ´ð£º

csvÎļþת»»³Ésqlµ¼Èëµ½Êý¾Ý¿â£¬Ã»ÓÐÊý¾ÝΪºÎ£¿

Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......

sqlÓï¾ä¶à±í¶à×ֶβéѯ - MS-SQL Server / »ù´¡Àà

ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд 

ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......

Ò»¸öpl/sqlÎÊÌâ - Oracle / ¿ª·¢

ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
  declare
  TYPE test_rec IS record(
  code varchar(10),
  name varchar(30)
  );
  v_book test_rec;
    ......

ÈçºÎʹÓÃMySQL - MS-SQL Server / »ù´¡Àà

¸Õ¸Õ½Ó´¥MySQL,²»ÖªµÀ¸ÃÈçºÎÈ¥²é¿´Êý¾Ý£¬²åÈëÊý¾Ý£¬´´½¨Êý¾Ý¿â¡¢±í£¬ÓÃÄÄΪǰ±²ÄÜÖ¸½ÌÒ»¶þ£¿

MySQL 5.1²Î¿¼ÊÖ²á

ÒýÓÃ
ÐÖµÜÄã»á½áÌùÂð£¿
mysql ²Î¿¼ÊÖ²á

baidu

MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc ......

Á½¾äSQL²¢Ò»¾ä,ÓÐÎÊÌâ. - MS-SQL Server / »ù´¡Àà

µÚÒ»¾ä:
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. ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ