ÈçºÎÆÁ±ÎSQLSERVERµÇ¼Óû§ºÍÆô¶¯µÇ¼Óû§
ÈçºÎÆÁ±ÎSQLSERVERµÇ¼Óû§ºÍÆô¶¯µÇ¼Óû§
ÆÁ±ÎʲôÒâ˼¡£¡£¡£¡£
°²ÐÔÐÔ,µÇ¼Ãû,Ñ¡ÔñµÇ¼Óû§,ÓÒ¼üÊôÐÔ,״̬,½ûÓõǼ
SQL Server Management Studio-->°²È«ÐÔ-->µÇ¼Ãû-->Ñ¡ÔñµÇ¼Óû§-->ÓÒ¼üÊôÐÔ-->״̬-->½ûÓÃ/ÆôÓõǼ
ΪʲôÎÒÓÒ¼üÊôÐÔûÓÐ×´Ì¬ÄØ~ÎÒµÄÊÇ2000
2000ûÓÐ
Ïà¹ØÎÊ´ð£º
ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð»
ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡
¹Ø×¢¡«¡«
Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿
......
Ҫת³ÉÒ»ÑùµÄЧ¹û£¬ÓÃpowerdesignerÔõôת£¿ÄÜתÂð£¿
create table publishers (
publisherID int identity,
publisherName varchar (30) NOT NULL,
constraint pk_publishers primary key (publisherID)
)& ......
ÈçºÎ½«SqlServerÊý¾Ý¿âÖеÄÊý¾Ýµ¼Èëµ½ExcelÖУ¿
ÓÃsql server ×Ô´øµÄ¹¤¾ß
ÒýÓÃ
ÓÃsql server ×Ô´øµÄ¹¤¾ß
SQL²éѯ·ÖÎöÆ÷
DTSµ¼Èëµ¼³öÊý¾Ý
¿ÉÒÔÓÃSqlServer×Ô´øµÄ¹¤¾ß
ËùÓÐÈÎÎñ£µ¼³öÊý¾Ý¡£
ÄãÏÈÓòéÑ ......
±àºÅ ¼¶±ð Ãû³Æ Éî¶È
1 0 ÐÂÎÅ 1
2 0 ²Æ¾ 1
3 1 ¾üÊ 2
4 2 ¹ÉƱ 3
5 0 ·¿²ú 1
6 1 Çé¸Ð 2
7 1 ¹úÄÚ 2
8 1 ¹ú¼Ê 2
14 2 ÓÊÕþµçÐÅ 2
15 2 »·±£ 2
16 5 ITÆó ......
ÓÐʲô¹¤¾ß¿ÉÒÔ°ÑsqlserverµÄÊý¾ÝÉú³Éinsert intoµÄ½Å±¾?ÏñmysqlÄÇÑùµ¼³ö.sqlÎļþ.
mssqlÖ»¿ÉÒÔÉú³É±í½á¹¹µÄsqlÎļþ.²»´øÊý¾ÝµÄ.
Èç¹û±íÉٵϰ
×Ô¼ºÆ´°É
Â¥Ö÷˵µÄÊÇÒª°ÑÊý¾Ý¿âÄÚµÄÒѲåÈëµÄÊý¾ÝתΪSQL½Å±¾?
......