Bcp导出数据库数据为CSV文件(不带表头)

EXEC master..xp_cmdshell 'BCP IPVA_Builder.dbo.Build_GetCsvResLog OUT E:\123\Build_GetCsvResLog.csv -c -t, -T ‘

/****** Object: StoredProcedure [dbo].[Export_FormatCSV] Script Date: 06/15/2017 16:02:27 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Export_FormatCSV]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[Export_FormatCSV] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Export_FormatCSV]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'-- ============================================= -- Author: tanxh -- Create date: 2017-6-15 -- Description: 导出数据库中所有表的数据为csv文件,每个表单独导出 -- [dbo].[Export_FormatCSV] ''E:\123\'' -- ============================================= CREATE PROCEDURE [dbo].[Export_FormatCSV] @path nvarchar(1000) AS BEGIN declare @n int,@count int declare @DBName nvarchar(100) declare @TableName nvarchar(100) declare @SQL nvarchar(1000) create table #TableName ( ID INT IDENTITY(1,1), Name nvarchar(100) ) insert into #TableName select name from sysobjects where xtype=''u'' select @DBName=DB_NAME() select @count=COUNT(*) from #TableName set @n=1 while(@n<=@count) begin select @TableName=Name from #TableName where ID=@n set @SQL=''BCP ''+@DBName+''.dbo.''+@TableName+'' OUT ''+@path+''''+@TableName+''.csv -c -t, -T '' EXEC master..xp_cmdshell @SQL set @n=@n+1 end drop table #tablename END ' END GO