shell½Å±¾¶ÁÈ¡rrdÎļþ½«Êý¾Ý²åÈësqlserverÊý¾Ý¿âÖÐ
ÓÃshell½Å±¾Ð´¸öС³ÌÐò£¬²»Í£µÄ¶ÁÈ¡rrdÎļþ£¬½«Êý¾Ý²åÈësqlserverÊý¾Ý¿âÖУ¬Çë¸ßÊÖ ½â´ð£¬ÔÚÏߵȣ¡£¡£¡
²»ÑÏÖØ£¬¿ÉÒÔ·ÃÎʱðµÄ·þÎñÆ÷µÄÊý¾Ý¿âÂð£¿
¸øÄãÒ»¸ö˼·£º
shell½Å±¾¶ÁÈ¡Îļþ£º¼ÙÉèÊý¾ÝÎļþÖÐÒ»ÐÐÊÇÒ»Ìõ¼Ç¼£¬¸ù¾Ý·Ö¸ô·ûºÍÊý¾Ý¿â±í½á¹¹£¨²é¿´Êý¾Ý¿â±í½á¹¹Ò²ÐèÒªµÇ¼Êý¾Ý¿â²éѯ£©À´Éú³ÉÏàÓ¦µÄinsertÓï¾ä£¬
È»ºóµÇ¼sqlserverÊý¾Ý¿â£¬Ö´Ðз½²ÅÉú³ÉµÄinsertÓï¾ä¼´¿É¡£
sqlserver²»ÖªµÀÔõÑùÁ¬½Ó£¬Èç¹ûÊÇmysqlµÄ£¬¿ÉÒÔÓÿͻ§¶ËÁ¬½Ó¡£orcalÒ²¿ÉÒÔÓÃsqlplusÁ¬½Ó¡£
Ö»ÒªÄÜÁ¬½ÓÉÏ£¬ÎÊÌâ¾Í¸ã¶¨ÁË£¬ÖÁÓÚ¶ÁÎļþ£¬²åÈëÊý¾Ý¶¼ºÜ¼òµ¥ÁË¡£
Ïà¹ØÎÊ´ð£º
ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð»
ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡
¹Ø×¢¡«¡«
Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿
......
ÔÚÊý¾Ý¿âÖÐÓÐÕÅ±í£¬ÓÐid,nameÁ½ÁУ¬id ÊÇÖ÷¼ü,ûÓÐÉèÖÃ×ÔÔöÊôÐÔ,ÔÚ³ÌÐòÖÐÈ¡³öÕâÕűí·ÅÈëdatatable£¬ÔÚÕâ¸ödatatableÖвåÈëÒ»Ìõ¼Ç¼£¬µ±¸üÐÂÊý¾Ý¿âʱÌáʾidÁв»ÄÜΪ¿Õ£¬ÇëÎʸÃÔõô½â¾ö£¿
¸øËüÒ»¸öÖµ£¡£¡Ö÷¼ü²»ÄÜΪ¿Õ ......
ÈçºÎ½«SqlServerÊý¾Ý¿âÖеÄÊý¾Ýµ¼Èëµ½ExcelÖУ¿
ÓÃsql server ×Ô´øµÄ¹¤¾ß
ÒýÓÃ
ÓÃsql server ×Ô´øµÄ¹¤¾ß
SQL²éѯ·ÖÎöÆ÷
DTSµ¼Èëµ¼³öÊý¾Ý
¿ÉÒÔÓÃSqlServer×Ô´øµÄ¹¤¾ß
ËùÓÐÈÎÎñ£µ¼³öÊý¾Ý¡£
ÄãÏÈÓòéÑ ......
´ó¼ÒºÃ ×î½üÓöµ½µãÂé·³ Çë´ó¼Ò°ïæ ÈçÏ £º
ÎÒÔÚÒ»¸öѧÉúµÄÊý¾Ý¿â STU ÖвéѯSTUDENTS ±íÖÐ Ïà¹ØµÄÊý¾Ý
CREATE TABLE STUDENTS
(
ID INT IDENTITY(1,1) PRIMARY KEY ,
[NAME] VARCHAR(20) N ......