°Ñµ±Ç°Êý¾Ý¿âÖбíµÄÊý¾Ý µ¼³É insert into Óï¾ä
±ÈÈç µ±Ç°Êý¾Ý¿âÖÐÓÐÒ»°ÙÌõÊý¾Ý
ÎÒÈçºÎÄÜ ÈÃSqlServer ×Ô¶¯´´½¨Ò»°Ù¸ö insert into Óï¾ä
µ±È» ÓÐ union Ò²¿ÉÒÔ
Âé·³¸÷λ°ï°ïæÁË
SQL code:
SELECT * INTO TB from TBB
?
ÓбØÒªÕâÑùÂ𡣡£
Ôõô×öµ½ÄØ
µ¼³ÉÍⲿµÄÎļþ
100ÐÐÊý¾Ý£¬100¸öinsert£¿
Èç¹ûlzÒªµ¼ÈëÊý¾ÝµÄ»°£¬ÅúÁ¿Ò²¾Í¿ÉÒÔÁË°¡£¡
Ò»ÌõÒ»¸öinsert£¬Ã»ÓбØÒªµÄ˵...
ÎÒÒªµ¼³ÉÍⲿµÄÎļþ ´ò°üµÄʱºò ʹÓà ½Å±¾´´½¨Êý¾Ý¿â ´´½¨±í ²åÈëÊý¾Ý
????
http://blog.csdn.net/feixianxxx/archive/2009/07/21/4365576.aspx
ÔÚÒ»¸öÎļþÖÐ º¬ÓÐ
insert into values ····
È»ºó´ò°ü °²×°µÄÊÇ Ö´ÐÐ ÕâЩÓï¾ä
EXEC master..xp_cmdshell 'BCP NTS.dbo.T_User out c:\User.txt -c -U"sa" -P"password"'
¼òµ¥µÄ
Ïà¹ØÎÊ´ð£º
ÔÚSqlServerÖÐÈçºÎ²é¿´ÀúÊ·ÉÏÖ´ÐеĴ洢¹ý³ÌµÄÐÅÏ¢ÄØ£¬È磺´«Èë²ÎÊý£¬Ö´ÐÐʱ¼äµÈµÈ¡£Èç¹û²»Äܲ鿴ÀúÊ·¼Ç¼£¬ÊÇ·ñ¿ÉÒÔ×Ô¼ºÐ´´¥·¢Æ÷Ö®ÀàµÄ£¬È˹¤¿ØÖÆÄØ£¬ÔÚOracleÀïÃæÓж¯Ì¬ÊÓͼ¿ÉÒÔËæʱ²é¿´ÀúÊ·Ö´ÐеÄsqlÓï¾ä£¬SqlSer ......
Ҫת³ÉÒ»ÑùµÄЧ¹û£¬ÓÃpowerdesignerÔõôת£¿ÄÜתÂð£¿
create table publishers (
publisherID int identity,
publisherName varchar (30) NOT NULL,
constraint pk_publishers primary key (publisherID)
)& ......
´ÓÍøÉϲ鵽µÄ×ÊÁÏ˵£¬ÈκÎÊý¾ÝÀàÐÍÓëNULLÖµ½øÐмÆË㣬½á¹û¶¼½«ÎªNULL.
select null-1
½á¹ûÊÇnull
¿ÉÊÇÏÂÃæÕâ¸ö²éѯΪʲô»á³ö´íÄØ£¿
select isnull(null-1,'test');
¾ÓÈ»±¨´í˵½«varcharתΪintʧ°Ü¡£
Ϊʲô» ......
ÎÒÓÃ insert into table select * from '+
'OpenDataSource(''Microsoft.Jet.OLEDB.4.0'',''Data Source=" ......