导出:
declare @sql varchar(500)
set @sql = 'bcp "select right(''00000''+convert(nvarchar(30),bh),5),convert(char(8),rq,112),left(convert(char(8),sj,108),5),right(100000+jh,4),null from KQ.dbo.yskqnew where rq=convert(char(8),getdate()-1,112) order by 3,1" queryout d:/'+CONVERT(VARCHAR(8),dateadd(day, -1,getdate()),112)+'060606.txt -c -U sa -P Qwer1234 -t "|" '
select @sql
EXEC master..xp_cmdshell @sql
导入:
Bulk
insert pmc_file
from
'E:/HR_SAP_DATA/pmc.txt'
with
(fieldterminator='|',rowterminator='/n')