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

½«ExcelÖеÄÊý¾Ýµ¼Èëµ½SQL Server 2000Êý¾Ý¿âÖÐ


½«ExcelÖеÄÊý¾Ýµ¼Èëµ½SQL Server 2000Êý¾Ý¿âÖÐ
    1¡¢´ò¿ªÆóÒµ¹ÜÀíÆ÷£¬´ò¿ªÒªµ¼ÈëÊý¾ÝµÄÊý¾Ý¿â£¬ÔÚ±íÉϰ´ÓÒ¼ü£¬ËùÓÐÈÎÎñ-->µ¼ÈëÊý¾Ý£¬µ¯³öDTSµ¼Èë/µ¼³öÏòµ¼£¬°´ ÏÂÒ»²½ £¬
   2¡¢Ñ¡ÔñÊý¾ÝÔ´ Microsoft Excel 97-2000£¬ÎļþÃû Ñ¡ÔñÒªµ¼ÈëµÄxlsÎļþ£¬°´ ÏÂÒ»²½ £¬
   3¡¢Ñ¡ÔñÄ¿µÄ ÓÃÓÚSQL Server µÄMicrosoft OLE DBÌṩ³ÌÐò£¬·þÎñÆ÷Ñ¡Ôñ±¾µØ(Èç¹ûÊDZ¾µØÊý¾Ý¿âµÄ»°£¬Èç VVV)£¬Ê¹ÓÃSQL ServerÉí·ÝÑéÖ¤£¬Óû§Ãûsa£¬ÃÜÂëΪ¿Õ£¬Êý¾Ý¿âÑ¡ÔñÒªµ¼ÈëÊý¾ÝµÄÊý¾Ý¿â£¨Èç client£©£¬°´ ÏÂÒ»²½ £¬
   4¡¢Ñ¡Ôñ ÓÃÒ»Ìõ²éѯָ¶¨Òª´«ÊäµÄÊý¾Ý£¬°´ ÏÂÒ»²½ £¬
   5¡¢°´ ²éѯÉú³ÉÆ÷£¬ÔÚÔ´±íÁбíÖУ¬ÓÐÒªµ¼ÈëµÄxlsÎļþµÄÁУ¬½«¸÷ÁмÓÈëµ½ÓÒ±ßµÄ Ñ¡ÖеÄÁÐ ÁбíÖУ¬ÕâÒ»²½Ò»¶¨Òª×¢Ò⣬¼ÓÈëÁеÄ˳ÐòÒ»¶¨ÒªÓëÊý¾Ý¿âÖÐ×ֶζ¨ÒåµÄ˳ÐòÏàͬ£¬·ñÔò½«»á³ö´í£¬°´ ÏÂÒ»²½ £¬
   6¡¢Ñ¡ÔñÒª¶ÔÊý¾Ý½øÐÐÅÅÁеÄ˳Ðò£¬ÔÚÕâÒ»²½ÖÐÑ¡ÔñµÄÁоÍÊÇÔÚ²éѯÓï¾äÖÐ order by ºóÃæËù¸úµÄÁУ¬°´ ÏÂÒ»²½ £¬
   7¡¢Èç¹ûҪȫ²¿µ¼È룬ÔòÑ¡Ôñ È«²¿ÐУ¬°´ ÏÂÒ»²½£¬
   8¡¢Ôò»á¿´µ½¸ù¾ÝÇ°ÃæµÄ²Ù×÷Éú³ÉµÄ²éѯÓï¾ä£¬È·ÈÏÎÞÎóºó£¬°´ ÏÂÒ»²½£¬
   9¡¢»á¿´µ½ ±í/¹¤×÷±í/ExcelÃüÃûÇøÓò ÁÐ±í£¬ÔÚ Ä¿µÄ ÁУ¬Ñ¡ÔñÒªµ¼ÈëÊý¾ÝµÄÄǸö±í£¬°´ ÏÂÒ»²½£¬
   10¡¢Ñ¡Ôñ Á¢¼´ÔËÐУ¬°´ ÏÂÒ»²½£¬
   11¡¢»á¿´µ½Õû¸ö²Ù×÷µÄÕªÒª£¬°´ Íê³É ¼´¿É¡£


Ïà¹ØÎĵµ£º

SQL³£¼û²éѯÎÊÌâ(±à³Ì)


ÓÐЩ³£¼ûµÄÎÊÌâÔÚÂÛ̳Öв»¶Ï³öÏÖ£¬²»·ÁÕûÀíһϡ£
ÒÔÏÂÓï¾äÊÇÔÚSQLServer2005ÉÏʵÏֵģ¬Ò»Ð©Óï¾äÎÞ·¨ÔÚSS2000ÉÏÖ´ÐС£
ÓÐÓÃÖ¸ÊýÊÇÎÒ¸ù¾ÝÕâ¸öÎÊÌâµÄ³£¼û³Ì¶È´òµÄ·Ö£¬½ö¹©²Î¿¼¡£Êµ¼ÊÉÏ£¬µ±ÄãÓöµ½ÁËÕâ¸öÎÊÌ⣬Õâ¸öÎÊÌâÄÄÅÂÔÙÉÙ¼û£¬½â¾ö·½°¸Ò²ÊǷdz£ÓÐÓõġ£
1. Éú³ÉÈô¸ÉÐмǼ
ÓÐÓÃÖ¸Êý£º¡ï¡ï¡ï¡ï¡ï
³£¼ûµÄÎÊÌâÀàÐÍ£º¸ù ......

OracleÖÐSQL PLUSµÄ³£ÓÃÖ¸Áî

½øÈësql*plusÐèÒªÊäÈëÓû§Ãû¡¢¿ÚÁîºÍÖ÷»ú±êÖ¾·û
system/manager
sys/change_on_intall
scott/tiger
internal/oracle
ÒÔÉÏΪ³õʼÃÜÂë
Ö÷»ú×Ö·û´®¿Õ»òÕßÊÇ@+ÄãµÄ·þÎñÃû,ÔÚ±¾µØµÇ½²»ÐèÒª±¾µØ·þÎñÃû¡£
ÏÂÃæ¾Í½éÉÜÒ»ÏÂһЩ³£ÓõÄsql*plusÃüÁ
Ê×ÏȲ鿴µ±Ç°Ê¹ÓõÄÊý¾Ý¿âʵÀý:
select name from V$database;
Çл»Á½¸ö ......

[¼Ç¼]ÔÚÃüÁîÐÐÖÐÆô¶¯ SQL SERVER

Æô¶¯ MS SQL SERVER £¨2000 £­2008¶¼ÊÊÓã©£º
cmd>net start mssqlserver
Æô¶¯ ·ÇȱʡʵÀý£º
cmd>net start mssql$[instance name]
×¢£ºÃüÁîÐÐÐèÒªÓÐAdministratorȨÏÞ¡£
Í£Ö¹SQLSERVER ·þÎñÆ÷:
cmd>net stop mssqlserver
cmd>net stop mssql$[instance name] ......

sql³õ¼¶Óï·¨ ±Ê¼Ç×ܽá

num_field   number(12,2); 
±íʾnum_fieldÊÇÒ»¸öÕûÊý²¿·Ö×î¶à10λ¡¢Ð¡Êý²¿·Ö×î¶à2λµÄ±äÁ¿¡£ 
case.....when Ó÷¨£¨Óëdecode£¨£©×÷ÓúÜÏñ£©
select case zsxm_dm
         when '02' then
          'Ó ......

ÓÃIP·ÃÎÊSQL Server 2008

1¡¢¿ªÊ¼->³ÌÐò-->Microsoft SQL Server 2005>ÅäÖù¤¾ß->SQL Server Configuration Manager->SQL Server 2005 ÍøÂçÅäÖà ->“xxx£¨ÄúµÄÊý¾Ý¿â£©”µÄЭÒ飬ÈçÏÂͼ
½«“Named Pipes”ºÍ“TCP/IP”µÄ״̬µ÷³É“ÆôÓÔ£¬·½·¨ÊÇÔÚ“Named Pipes”ºÍ“T ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ