改为如下,不需引号 EXEC master..xp_cmdshell ’bcp dbname..tablename in c:\DT.txt -c -Sservername -Usa -Ppassword’
/** 导出文本文件 EXEC master..xp_cmdshell ’bcp "dbname..tablename" out c:\DT.txt -c -Sservername -Usa -Ppassword’ 此句需加引号
Copyright 2003-2005 www.sohozu.com All Rights Reserved
上一页 [1] [2] [3] [4] [5] [6] [7]
|