Re:SQL导出文件

EXEC master..xp_cmdshell 'bcp test..test in d:\abc.txt -c -S(local) -Usa -P123456'

exec master..xp_cmdshell 'copy "d:\abc.txt" "d:\abcd.txt"'

exec master..xp_cmdshell 'bcp "select * from test..CustomerInfo" queryout d:\abc.xls -c -T'

posted @ 2007-08-23 16:02  zhangh  阅读(180)  评论(0)    收藏  举报