回复：请教个问题,如何使导出数据的目的文件名是动态变化的
我以前做过类似的:
declare @sql varchar(1000)
set @sql = 'bcp "select CaseNumber, isnull(CardNum, ''无'') as CardNum, CustomerName, convert(varchar(10), SendFormDate, 120) Date, convert(varchar(20), convert(int, PaidUpPrice)) as Points, convert(varchar(20), PaidUpPrice) as price from CRMv4DWRaw.dbo.View_EasternAirMonthly UNION select '' TID'' as CaseNumber, ''CID'' as CardNum, ''Name'' as Customer,''Date'' as Date, ''POINTS'' as Points, ''MONEY'' as Price" queryout d:\东航数据\东航-'+CONVERT(VARCHAR(6),dateadd(m, -1,getdate()),112)+'.txt -c -S10.1.1.218\dw2005 -USSIS_Job -PChemeng01!'
select @sql
EXEC master..xp_cmdshell @sql
你看一下,主要工作比较忙,所以就直接把原来写的script粘上来了,你研究一下吧!
