Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ : sqlserver

ÈçºÎ½«SqlServerÊý¾Ý¿âÖеÄÊý¾Ýµ¼Èëµ½ExcelÖÐ

ÈçºÎ½«SqlServerÊý¾Ý¿âÖеÄÊý¾Ýµ¼Èëµ½ExcelÖУ¿
ÓÃsql server ×Ô´øµÄ¹¤¾ß

ÒýÓÃ
ÓÃsql server ×Ô´øµÄ¹¤¾ß
SQL²éѯ·ÖÎöÆ÷

DTSµ¼Èëµ¼³öÊý¾Ý
¿ÉÒÔÓÃSqlServer×Ô´øµÄ¹¤¾ß

ËùÓÐÈÎÎñ£­µ¼³öÊý¾Ý¡£

ÄãÏÈÓòéѯ·ÖÎöÆ÷°ÑÐÅÏ¢²é³öÀ´£¬È»ºó°ÑÐÅÏ¢¸ºÖƳöÀ´¡£·Åµ½Excel¾Í¿ÉÒÔÁË

2003Ö»ÄÜ¿½±´6Íò¶àÐУ¬Òª×¢Òâ

Èç¹ûÊý¾ ......

windows server 2003Íü¼ÇÃÜÂ룬¿ÉÒÔSqlServer¿ÉÒÔÁ¬ÉÏ

ÎҼǵÃsqlserverÖÐÓдúÂë¿ÉÒÔÖ±½Ó´´½¨Ò»¸öÓû§µÄ£¬ÇëÄÄλָµãÏ£¡
ºÃÏñÒªÓõ½xp_cmdshellÀ´´´½¨windowsÓû§£¬¾ßÌåµÄÄã¿ÉÒÔgoogleÒ»ÏÂ

ÄãÁ¬ÉϵÄÓû§Èç¹ûÄÜÓÃxp_cmdshellµÄ»°£¬¾ÍÓðɡ£

xp_cmdshell 'net user Óû§/add'

SQL code:
xp_cmdshell 'NET USER username password /ADD'
xp_cmdshell 'NE ......

ÈçºÎ½«SqlServerÊý¾Ý¿âÖеÄÊý¾Ýµ¼Èëµ½ExcelÖУ¿

ÈçºÎ½«SqlServerÊý¾Ý¿âÖеÄÊý¾Ýµ¼Èëµ½ExcelÖУ¿
Ñ¡ÔñÊý¾Ý¿â£¬µã»÷ÓÒ¼ü ÈÎÎñ->µ¼³öÊý¾Ý Ö®ºó°´ÕÕÌáʾµ¼³ö¾Í¿ÉÒÔÁË£¡

±í¶àµÄ»° ÓÃÂ¥Éϵķ½·¨ ±È½Ï·½±ã ¿ÉÒÔ°ÑÊý¾Ý¿âÀïÏàÓ¦µÄ±íµ¼³ö »òÕßÈç¹ûÄãÊDzéѯ³öÀ´µÄ½á¹ûµÄ»°  
Äã°ÑÒª¸´ÖƳöÀ´µÄÊý¾ÝÑ¡ÉÏ£¬È»ºóÏÂÒ»²½¾ÍÖ±½Ó¸´ÖƵ½±íÀï ¾Í¿ÉÒÔÁË
......

¹ØÓÚSQLserverÁ¬½ÓµÄÎÊÌâ

  ÎÒ×°ÁËSQLserver2000¡¢SQLserver2005ÕâÁ½¸öÊý¾Ý¿â£¬ÔõôÁ¬½ÓÕâÁ½¸öÊý¾ÝÄØ£¿£¨¿ª·¢¹¤¾ßΪmyEclipse£©

  ÎÒÓÃJDBCÁ¬½ÓÉÏÁËSQLserver2005,¼ÓÈëÁËÈý¸öÇý¶¯°ü(Ìý˵ÕâÈý¸öÇý¶¯ÊÇÓÃÓÚÁ¬½ÓSQLserver2000µÄ)£¬Çý¶¯ÃûΪcom.microsoft.jdbc.sqlserver.SQLServerDriver£¬½á¹ûÁ¬½ÓÉÏÁË

Èç¹ûÎÒÏëÁ¬½ÓSQLserv ......

NetBeansÁ¬½ÓSqlserverÎÊÌâ

ÓÃNetBeans×Ô¶¯´´½¨ÁËÒ»¸öÊý¾Ý¿âÓ¦ÓóÌÐò£¨Ò»¸ö×ÀÃæÓ¦ÓóÌÐò£©£¬ÊµÏÖ»ù±¾µÄ¶Ô±íµÄÌí¼Ó¡¢É¾³ý¡¢Ð޸ġ¢Ë¢Ð£¬ÀïÃæÉú³ÉÁËÈý¸öÎļþ£¬Ò»¸öÊÇGUIÏÔʾ£¬Ò»¸öÊÇÈë¿ÚÎļþ£¨ launch(CarsApp3App.class, args)£©»¹ÓÐÒ»¸öÎļþ£¬ÎÒÍƲâÊÇÓйØÊý¾Ý¿âµÄ£¬µ«ÊÇ¿´²»Ì«Ã÷°×¡£
¸÷λÄÜ·ñ°ïæ¿´¿´£¬´óÖ½âÊÍһϣ¿
--------------------------- ......

JforumÂÛ̳£¬ÔÚsqlserverÉÏ~~~~~~~~~~~~~³öÏÖ

´ø¸½¼þµÄÌû×Ó·¢ËÍʧ°ÜµÄÇé¿ö¡£ÌáʾÕÒ²»µ½sqlÎÊÌâ¡£µ«ÊDz»´ø¸½¼þµÄ¾Í¿ÉÒÔ·¢Ëͳɹ¦¡£²»ÖªµÀΪʲô°¡¡£ÓÐÈËÓöµ½¹ýÂð£¿
Ï£Íû´ó¼Ò°ïæ°¡55


º¹~»Ø¸´ÄÚÈÝÌ«¶ÌÁË£¡

º¹~»Ø¸´ÄÚÈÝÌ«¶ÌÁË£¡

JforumÊDz»ÊÇÓлúÖÆÏÈ×Ô¶¯¸ù¾ÝdbÔÚ²»Í¬µÄxx.sqlÎļþÀïÃæ»ñÈ¡sqlÓï¾ä£¬µ«ÊÇÈç¹û»ñÈ¡²»µ½sqlÓï¾ä¾ÍÈ¥ generic_queries.sqlÕâ¸öÎļ ......
×ܼǼÊý:322; ×ÜÒ³Êý:54; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [5] [6] [7] [8] 9 [10] [11] [12] [13] [14]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ