环境:Win2003Server + MSSQL Server2005
操作语句:
declare @sql nvarchar(500)
set @sql='bcp "Select LogData from TestDB..TableData" queryout "c:\DT.txt" -T -c'
--select @sql
EXEC master..xp_cmdshell @sql
Go输出结果:
output
---------------------------------
'bcp' is not recognized as an internal or external command,
operable program or batch file.
NULL
为什么会提示“'bcp' is not recognized as an internal or external command,”呢?
操作语句:
declare @sql nvarchar(500)
set @sql='bcp "Select LogData from TestDB..TableData" queryout "c:\DT.txt" -T -c'
--select @sql
EXEC master..xp_cmdshell @sql
Go输出结果:
output
---------------------------------
'bcp' is not recognized as an internal or external command,
operable program or batch file.
NULL
为什么会提示“'bcp' is not recognized as an internal or external command,”呢?
试一下这样
你在一个数据库里面吧你需要查询的sql 建立成一个视图(或者存储过程) 然后吧bcp 里面的sql 替换为 select *from 你的视图名称即可。
declare @sql nvarchar(500)
set @sql='C:\Program Files\Microsoft SQL Server\90\Tools\Binn\bcp.exe "Select LogData from TestDB..TableData" queryout "c:\DT.txt" -T -c'
--select @sql
EXEC master..xp_cmdshell @sql
Go
试了不行,
不过,我还是想知道怎样用命令来导出!
set @sql='cd "C:\Program Files\Microsoft SQL Server\90\Tools\Binn\"&bcp "Select LogData from TestDB..TableData" queryout "c:\DT.txt" -T -c'
EXEC master..xp_cmdshell @sql
Go
RECONFIGURE;
EXEC sp_configure 'xp_cmdshell', 1;
RECONFIGURE;
->系统环境变量->PATH->最后加一个分号->再加上C:\Program Files\Microsoft SQL Server\90\Tools\Binn
报这个错,