ÇóSQLÓï¾ä - MS-SQL Server / »ù´¡Àà

Êý¾Ý¿â±íÃûstudent_info ʹÓòéѯÓï¾äselect * from student_info;ÇóSQLÓï¾äʹµÃÔÚ²éѯ·ÖÎöÆ÷ÖÐËùµÃµ½µÄÊý¾Ýµ¼³ö³ÉΪһÕÅEXCEL»òÕßÊÇCSV¡¢TXT¸ñʽµÄÎļþµ½C:\student Ï£»

---

BCP µ¼Èëµ¼³ö¹¦ÄÜ

---

EXEC master..xp_cmdshell 'bcp "select * from student_info" queryout C:\student\student_info.txt -c -Sservername -Usa -Ppassword' 

---

ѧϰÁË~

---

ÔÎ ¿´À´ÎÒµÃÕÒÏà¸É×ÊÁÏѧϰϲÅÐС¢¡¢

---

EXEC master..xp_cmdshell 'bcp "select * from student_info" queryout C:\student\filename.xls -c -Sservername -Usa -Ppassword'

---

лСF×ÊÁÏ

---

ÒýÓÃ

SQL code
SQL SERVER ºÍEXCELµÄÊý¾Ýµ¼Èëµ¼³ö
1¡¢ÔÚSQL SERVERÀï²éѯExcelÊý¾Ý:
-- ======================================================
SELECT *
from OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="c:\bo¡­¡­

up.........