ÈçºÎ²ÅÄÜÌá¸ß³ÌÐòÔËÐÐЧÂÊ£¿£¨sqlserver 2005£©
Ò»¸öÄ£Äâ½»Ò×ϵͳ£¬Ã¿Ì춼»áÔËÐдóÀí½áËã´æ´¢¹ý³ÌÀ´½øÐнáË㣬ÔÚÕâЩ´æ´¢¹ý³ÌÖж¼»áÓõ½Ò»Ð©¹²Í¬µÄ¿É±äÊý¾Ý£¬±ÈÈ籨¼Û¡¢·ÑÂʵȵȣ¬ÕâЩ¹²ÓõÄÊýÇü´ò³É¾Ý¶¼·ÅÔÚ²»Í¬µÄ±íÖУ¬ÎªÁËÌá¸ßϵͳÔËÐÐЧÂÊ£¬¶ÔÓÚÕâЩ¹²ÓõÄÊý¾ÝÔõô´¦Àí±È½ÏºÃÄØ£¬Ê¹Æä²»±Ø·´¸´²éѯÊý¾Ý¿â£¬ÇÒ²»ÄÜÔÚÌí¼ÓбíÁË£¿
Up! Ðí¶à´í×ÖŶ£¬ÖØз¢Ï£º Ò»¸öÄ£Äâ½»Ò×ϵͳ£¬Ã¿Ì춼»áÔËÐдóÁ¿´æ´¢¹ý³ÌÀ´½øÐнáË㣬ÔÚÕâЩ´æ´¢¹ý³ÌÖж¼»áÓõ½Ò»Ð©¹²Í¬µÄ¿É±äÊý¾Ý£¬±ÈÈ籨¼Û¡¢·ÑÂʵȵȣ¬ÕâЩ¹²ÓõÄÊý¾Ý¶¼·ÅÔÚ²»Í¬µÄ±íÖУ¬ÎªÁËÌá¸ßϵͳÔËÐÐЧÂÊ£¬¶ÔÓÚÕâЩ¹²ÓõÄÊý¾ÝÔõô´¦Àí±È½ÏºÃÄØ£¬Ê¹Æä²»±Ø·´¸´²éѯÊý¾Ý¿â£¬ÇÒ²»ÄÜÔÚÌí¼ÓбíÁË£¿ ¹²Í¬µÄ¿É±äÊý¾Ý½¨ÊÓͼ°É¡£ ÒÔÇ°ÌýÈË˵¹ýÎﻯÊÓͼ£¬²»ÖªµÀÈçºÎÓã¿ÓÐÈËÖªµÀ²»£¿ ºÃÌû×Ó,ºÇºÇ,ѧϰÁË,ºÇºÇ »òbcp AdventureWorks.sales.currency out c:\currency1.txt -c -T --ʹÓÃÐÅÈÎÁ¬½Ó ·¢ÏÖʧ°Ü ×ÜÊÇÌáʾ £º msg 102¡£level 15,state 1, line 1 incorrect syntax near '.' ²»ÖªµÀ´íÔÚʲôµØ·½ ÎҼǵÃÒÔÇ°ÊÇ¿ÉÒÔ (xp sql2005)ÒýÓà »òbcp AdventureWorks.sales.currency out c:\currency1.txt -c -T --ʹÓÃÐÅÈÎÁ¬½Ó ·¢ÏÖʧ°Ü ×ÜÊÇÌáʾ £º msg 102¡£level 15,state 1, line 1 incorrect syntax near '.' ²»ÖªµÀ´íÔÚʲôµØ·½ ÎҼǵÃÒÔÇ°ÊÇ¿ÉÒÔ (xp sql2005) ÄãÊÇÓÃɶÓû§½øÈ¥µÄ,Óû§ÃÜÂëÕýȷû os system ûÓÐÊäÈëÃÜÂë Ö±½ÓÓõÄosÈÏÖ¤½øÈ¥ µÄ -c -T --ʹÓÃÐÅÈÎÁ¬½Ó  
Ïà¹ØÎÊ´ð£º
ÊÇÕâÑùµÄ£¬ÎÒÓÃÊÇODBCÊý¾ÝÔ´Á¬½Ó·þÎñÆ÷µÄÊý¾Ý¿â£¬ÏÖÔÚÎÒ¾õµÃºÜÂé·³£¬ÒòΪҪΪÿÈç»úÌí¼Ó¶ÔÓ¦µÄÊý¾ÝÔ´£¬Ïë°ÑËû¸Ä³ÉADO·½·¨À´·ÃÎÊ·þÎñÆ÷µÄÊý¾Ý¿âÄÜʵÏÖÂð£¿ÒªÔõôд¡£ ±ÈÈç·þÎñÆ÷ÀïÓжþ¸öÊý¾Ý¿âdata1 ºÍdata2£¬¿Í»§ ......
Ҫת³ÉÒ»ÑùµÄЧ¹û£¬ÓÃpowerdesignerÔõôת£¿ÄÜתÂ𣿠create table publishers ( publisherID int identity, publisherName varchar (30) NOT NULL, constraint pk_publishers primary key (publisherID) )& ......
create trigger [trgDeleteEuser] on [dbo].[E_UserInfo] for delete as delete Job_Info from Job_Info j join Deleted d on j.user_name=d.user_name delete job_evaluation from job_evaluation ......
ÔÚÊý¾Ý¿âÖÐÈÕÆÚÈçÏÂÏÔʾ£º2009-2-27 9:40:47 Õâ¸ö²»ÊÇÎÒÏëÒªµÄ£¬ÎÒÐèÒªÔ·ݺÍʱ¼äÓÃÁ½Î»Êý±íʾ£¬ÉÏÃæµÄÓ¦¸Ãת»»Îª;2009-02-27 09:40:47 ÇëÎÊ 1¡¢ÈçºÎ¶ÔÏÖÓÐÈÕÆÚ½øÐÐת»»£¨Êý¾Ý¿âÖÐÒÑ´æÔÚÐí¶àÀàËƵÄÖµ£¬ÎÒÐèÒª½«Æä ......
ÈçÌâ: sqlserver 2005 Á½Ç§ÍòÌõÊý¾ÝÐÔÄÜÔõôÑù£¿ µÃ¿´ÄãµÄÊý¾Ý½á¹¹À´,Èç¹û²éѯʱȫÊÇLIKE Ö®Àà,ÄǾÍ.. ×îºÃÓÅ»¯ ²»Ëãʲô ºÜÕý³££¬²éѯµÄʱºò¶àÓÅ»¯£¬ÐÔÄÜ»¹ÊÇºÜºÃµÄ sqlserver 2005 Á½Ç§ÍòÌõÊý¾Ý Ö ......