ÈçºÎ½«SqlServerÊý¾Ý¿âÖеÄÊý¾Ýµ¼Èëµ½ExcelÖУ¿
ÈçºÎ½«SqlServerÊý¾Ý¿âÖеÄÊý¾Ýµ¼Èëµ½ExcelÖУ¿
Ñ¡ÔñÊý¾Ý¿â£¬µã»÷ÓÒ¼ü ÈÎÎñ->µ¼³öÊý¾Ý Ö®ºó°´ÕÕÌáʾµ¼³ö¾Í¿ÉÒÔÁË£¡
±í¶àµÄ»° ÓÃÂ¥Éϵķ½·¨ ±È½Ï·½±ã ¿ÉÒÔ°ÑÊý¾Ý¿âÀïÏàÓ¦µÄ±íµ¼³ö »òÕßÈç¹ûÄãÊDzéѯ³öÀ´µÄ½á¹ûµÄ»°
Äã°ÑÒª¸´ÖƳöÀ´µÄÊý¾ÝÑ¡ÉÏ£¬È»ºóÏÂÒ»²½¾ÍÖ±½Ó¸´ÖƵ½±íÀï ¾Í¿ÉÒÔÁË
Ïà¹ØÎÊ´ð£º
Ҫת³ÉÒ»ÑùµÄЧ¹û£¬ÓÃpowerdesignerÔõôת£¿ÄÜתÂð£¿
create table publishers (
publisherID int identity,
publisherName varchar (30) NOT NULL,
constraint pk_publishers primary key (publisherID)
)& ......
ÔÚŪһ¸öµ¼³öÊý¾Ý¿â¼Ü¹¹µÄС³ÌÐò Óöµ½ÎÊÌâÁË ÌØÀ´Çë½Ì£¡
ÎÒÏÖÔÚÏëͨ¹ýÒ»¸öÍâ¼üÃû×Ö È¥ÏµÍ³±íÀï²é³ö Ö÷±íÃû£¬ ¸½±íÃû£¬ Ö÷±í±»ÒýÓÃ×ֶΣ¬ ¸½±íÒýÓÃ×Ö¶Î µÄÐÅÏ¢¡£¡£ Î ......
ŪÁ˰ëÌì¶¼»¹ÊÇŪ²»ºÃ£¬ÔÚÓÃmyeclipse¿ª·¢ÖÐÒªÔõÃ´ÅªÄØ£¬
Ï£Íû˵˵¾ßÌå²½Öè
Ê×ÏÈÓ¦¸Ã°ÑÒì³£·ÅÉÏÀ´
Ò»°ãÈç¹ûÊÇÔÚXPϵͳÏÂ,×°ÉÏSP3»òSP4,´ò¿ª1433¶Ë¿Ú.....
netstat -an¿ÉÒԲ鿴ÊÇ·ñ´ò¿ªÁË1433¶ ......
ÈçºÎ½«SqlServerÊý¾Ý¿âÖеÄÊý¾Ýµ¼Èëµ½ExcelÖУ¿
ÓÃsql server ×Ô´øµÄ¹¤¾ß
ÒýÓÃ
ÓÃsql server ×Ô´øµÄ¹¤¾ß
SQL²éѯ·ÖÎöÆ÷
DTSµ¼Èëµ¼³öÊý¾Ý
¿ÉÒÔÓÃSqlServer×Ô´øµÄ¹¤¾ß
ËùÓÐÈÎÎñ£µ¼³öÊý¾Ý¡£
ÄãÏÈÓòéÑ ......
ÎҼǵÃsqlserverÖÐÓдúÂë¿ÉÒÔÖ±½Ó´´½¨Ò»¸öÓû§µÄ£¬ÇëÄÄλָµãÏ£¡
ºÃÏñÒªÓõ½xp_cmdshellÀ´´´½¨windowsÓû§£¬¾ßÌåµÄÄã¿ÉÒÔgoogleÒ»ÏÂ
ÄãÁ¬ÉϵÄÓû§Èç¹ûÄÜÓÃxp_cmdshellµÄ»°£¬¾ÍÓðɡ£
xp_cmdshell 'n ......