22,210
社区成员
发帖
与我相关
我的任务
分享
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
'bcp' is not recognized as an internal or external command,
operable program or batch file.
NULL
开启xp_cmdshell
EXEC sp_configure 'show advanced options', 1;RECONFIGURE;EXEC sp_configure 'xp_cmdshell', 1;RECONFIGURE;
EXEC sp_configure 'show advanced options', 1;
RECONFIGURE;
EXEC sp_configure 'xp_cmdshell', 1;
RECONFIGURE;
declare @sql nvarchar(500)
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
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