BCP用法

declare @fn nvarchar(max) = CONVERT(char(8),GETDATE(),112)+CONVERT(char(15),GETDATE(),114)
set @fn ='D:\文件\' +rtrim(replace(@fn,':',''))+'.xls'
SET @fn = 'EXEC master..xp_cmdshell'+'''bcp "select * from TOPLED2015..COPTDLog1" queryout ' + @fn + ' -c -q -T'''
EXEC(@fn)

    --带条件查询导出，
EXEC master..xp_cmdshell 'bcp "select * from TEST..Demo_A" queryout D:\Test\1.xls -c -q -T'
EXEC master..xp_cmdshell 'bcp "select * from TEST..Demo_A" queryout D:\Test\1.xls -c -q -S"." -U"sa" -P"123123"'
--所有表数据导出
EXEC master..xp_cmdshell 'bcp TEST.dbo.Demo_A out D:\Test\1.xls -c -q -T'
--导入数据，表结构一致
EXEC master..xp_cmdshell 'bcp TEST..Demo_A in D:\Test\1.xls -T -c'

--解决一些报错处理
-- To allow advanced options to be changed.
EXEC sp_configure 'show advanced options', 1
GO
-- To update the currently configured value for advanced options.
RECONFIGURE
GO
-- To enable the feature.
EXEC sp_configure 'xp_cmdshell', 1
GO
-- To update the currently configured value for this feature.
RECONFIGURE
GO