{"rsdb":{"rid":"372619","subhead":"","postdate":"0","aid":"261544","fid":"57","uid":"1","topic":"1","content":"
\n

SELECT INTO \u8bed\u53e5\u53ef\u7528\u4e8e\u521b\u5efa\u8868\u7684\u5907\u4efd\u590d\u4ef6\u3002<\/p> \n

\n

SELECT INTO \u8bed\u53e5<\/h2> \n

SELECT INTO \u8bed\u53e5\u4ece\u4e00\u4e2a\u8868\u4e2d\u9009\u53d6\u6570\u636e\uff0c\u7136\u540e\u628a\u6570\u636e\u63d2\u5165\u53e6\u4e00\u4e2a\u8868\u4e2d\u3002<\/p> \n

SELECT INTO \u8bed\u53e5\u5e38\u7528\u4e8e\u521b\u5efa\u8868\u7684\u5907\u4efd\u590d\u4ef6\u6216\u8005\u7528\u4e8e\u5bf9\u8bb0\u5f55\u8fdb\u884c\u5b58\u6863\u3002<\/p> \n

SQL SELECT INTO \u8bed\u6cd5<\/h3> \n

\u60a8\u53ef\u4ee5\u628a\u6240\u6709\u7684\u5217\u63d2\u5165\u65b0\u8868\uff1a<\/p> \n 

\tSELECT *\r\nINTO new_table_name [IN externaldatabase] \r\nFROM old_tablename\r\n<\/pre> \n  
\u6216\u8005\u53ea\u628a\u5e0c\u671b\u7684\u5217\u63d2\u5165\u65b0\u8868\uff1a<\/p> \n  
\tSELECT column_name(s)\r\nINTO new_table_name [IN externaldatabase] \r\nFROM old_tablename\r\n<\/pre> \n <\/div> \n 
 \n  
SQL SELECT INTO \u5b9e\u4f8b - \u5236\u4f5c\u5907\u4efd\u590d\u4ef6<\/h2> \n  
\u4e0b\u9762\u7684\u4f8b\u5b50\u4f1a\u5236\u4f5c "Persons" \u8868\u7684\u5907\u4efd\u590d\u4ef6\uff1a<\/p> \n  
\tSELECT<\/code> *\r\nINTO<\/code> Persons_backup\r\nFROM Persons\r\n<\/pre> \n  
IN \u5b50\u53e5\u53ef\u7528\u4e8e\u5411\u53e6\u4e00\u4e2a\u6570\u636e\u5e93\u4e2d\u62f7\u8d1d\u8868\uff1a<\/p> \n  
\tSELECT<\/code> *\r\nINTO<\/code> Persons IN<\/code> 'Backup.mdb'\r\nFROM Persons\r\n<\/pre> \n  
\u5982\u679c\u6211\u4eec\u5e0c\u671b\u62f7\u8d1d\u67d0\u4e9b\u57df\uff0c\u53ef\u4ee5\u5728 SELECT \u8bed\u53e5\u540e\u5217\u51fa\u8fd9\u4e9b\u57df\uff1a<\/p> \n  
\tSELECT<\/code> LastName,FirstName\r\nINTO<\/code> Persons_backup\r\nFROM Persons\r\n<\/pre> \n <\/div> \n 
 \n  
SQL SELECT INTO \u5b9e\u4f8b - \u5e26\u6709 WHERE \u5b50\u53e5<\/h2> \n  
\u6211\u4eec\u4e5f\u53ef\u4ee5\u6dfb\u52a0 WHERE \u5b50\u53e5\u3002<\/p> \n  
\u4e0b\u9762\u7684\u4f8b\u5b50\u901a\u8fc7\u4ece "Persons" \u8868\u4e2d\u63d0\u53d6\u5c45\u4f4f\u5728 "Beijing" \u7684\u4eba\u7684\u4fe1\u606f\uff0c\u521b\u5efa\u4e86\u4e00\u4e2a\u5e26\u6709\u4e24\u4e2a\u5217\u7684\u540d\u4e3a "Persons_backup" \u7684\u8868\uff1a<\/p> \n  
\tSELECT<\/code> LastName,Firstname\r\nINTO<\/code> Persons_backup\r\nFROM Persons\r\nWHERE<\/code> City='Beijing'\r\n<\/pre> \n <\/div> \n 
 \n  
SQL SELECT INTO \u5b9e\u4f8b - \u88ab\u8fde\u63a5\u7684\u8868<\/h2> \n  
\u4ece\u4e00\u4e2a\u4ee5\u4e0a\u7684\u8868\u4e2d\u9009\u53d6\u6570\u636e\u4e5f\u662f\u53ef\u4ee5\u505a\u5230\u7684\u3002<\/p> \n  
\u4e0b\u9762\u7684\u4f8b\u5b50\u4f1a\u521b\u5efa\u4e00\u4e2a\u540d\u4e3a "Persons_Order_Backup" \u7684\u65b0\u8868\uff0c\u5176\u4e2d\u5305\u542b\u4e86\u4ece Persons \u548c Orders \u4e24\u4e2a\u8868\u4e2d\u53d6\u5f97\u7684\u4fe1\u606f\uff1a<\/p> \n  
\tSELECT<\/code> Persons.LastName,Orders.OrderNo\r\nINTO<\/code> Persons_Order_Backup\r\nFROM<\/code> Persons\r\nINNER JOIN<\/code> Orders\r\nON<\/code> Persons.Id_P=Orders.Id_P<\/pre> \n <\/div> \n<\/div>","orderid":"0","title":"sql server\u4e4bSQL SELECT INTO \u8bed\u53e5","smalltitle":"","mid":"0","fname":"\u6570\u636e\u5e93\u7f16\u7a0b","special_id":"0","bak_id":"0","info":"0","hits":"52","pages":"1","comments":"0","posttime":"2019-09-19 11:12:00","list":"1568862720","username":"admin","author":"","copyfrom":"","copyfromurl":"","titlecolor":"","fonttype":"0","titleicon":"0","picurl":"https:\/\/www.cppentry.com\/upload_files\/","ispic":"0","yz":"1","yzer":"","yztime":"0","levels":"0","levelstime":"0","keywords":"sql<\/A> server<\/A> SQL<\/A> SELECT<\/A> INTO<\/A> \u8bed\u53e5<\/A>","jumpurl":"","iframeurl":"","style":"","template":"a:3:{s:4:\"head\";s:0:\"\";s:4:\"foot\";s:0:\"\";s:8:\"bencandy\";s:0:\"\";}","target":"0","ip":"14.17.22.32","lastfid":"0","money":"0","buyuser":"","passwd":"","allowdown":"","allowview":"","editer":"","edittime":"0","begintime":"0","endtime":"0","description":"sql server\u4e4bSQL SELECT INTO \u8bed\u53e5","lastview":"1712928735","digg_num":"0","digg_time":"0","forbidcomment":"0","ifvote":"0","heart":"","htmlname":"","city_id":"0"},"page":"1"}