ç®å主è¦æå°äºä¸ç§åæ³ï¼ä¸ç§å¨ç¨åºä¸è°ç¨DTSï¼äºç§ä½¿ç¨SQL SERVER带çBCPåè½ï¼ä¸ç§ä½¿ç¨openrowsetã
å
·ä½çä¸é¢ï¼
è¿æ¯å©ç¨BCPæ¥åçï¼
使ç¨SQLServerèªå¸¦çbcpå½ä»¤ââ
bcp æ°æ®åºå.dbo.表å out æ件å âc âq âSâæå¡å¨åâ âUâç¨æ·åâ âPâå¯ç â
bcp âselect è¯å¥â queryout æ件å âc âq âSâæå¡å¨åâ âUâç¨æ·åâ âPâå¯ç â
导åºæ´å¼ 表ï¼
EXEC master..xp_cmdshell 'bcp "inter_custom.dbo.out_ck1" out c:\Temp.xls -c -q -S"PETER" -U"sa" -P"
[email protected]"'
æ ¹æ®Queryè¯å¥å¯¼åºï¼
EXEC master..xp_cmdshell 'bcp "select * from inter_custom.dbo.out_ck1" queryout c:\Temp.xls -c -q -S"PETER" -U"sa" -P"
[email protected]"'
å©ç¨bcpè¦æ±æ°æ®åºçæå¡å¨åï¼æ°æ®åºç¨æ·ååå¯ç ï¼è¿äºå¿
é¡»ä¼ å°ç¨åºä¸ãæ¹æ³å¯ä»¥æå¾å¤ä¸