34,594
社区成员
发帖
与我相关
我的任务
分享
DECLARE @NowDate DATE;
DECLARE @StartDate DATETIME;
DECLARE @EndDate DATETIME ;
SET @NowDate = GETDATE();-
SELECT @StartDate = DATEADD(DAY,-1,@NowDate);
SET @EndDate=DATEADD(second,-1,CONVERT(DATETIME,@NowDate ));
SELECT [MemberHotelAct].[mCode]
,[MemberHotelAct].[HotelID]
,[MemberHotelAct].[BillCount]
,[MemberHotelAct].[SyncTag]
FROM [yumcloud].[dbo].[MemberHotelAct],[yumcloud].[dbo].[Member]
where [MemberHotelAct].mCode = [Member].mCode
and Member.StartDate between @StartDate and @EndDate
and [MemberHotelAct].SyncTag between @StartDate and @EndDate
order by [MemberHotelAct].HotelID
(1 行受影响)
消息 241,级别 16,状态 1,第 13 行
从字符串转换日期和/或时间时,转换失败。
请教在bcp中如何对查询语句中日期变量进行转化处理,感谢。declare @exec_sql varchar(200);--SQL语句;
set @exec_sql = 'SELECT [MemberHotelAct].[mCode]
,[MemberHotelAct].[HotelID]
,[MemberHotelAct].[BillCount]
,[MemberHotelAct].[SyncTag]
FROM [yumcloud].[dbo].[MemberHotelAct],[yumcloud].[dbo].[Member]
where [MemberHotelAct].mCode = [Member].mCode
and Member.StartDate between between '+@StartDate+' and '+@EndDate+'
and [MemberHotelAct].SyncTagbetween '+@StartDate+' and '+@EndDate+'
order by [MemberHotelAct].HotelID';
select @exec_sql
set @exec_sql = ' bcp "'+@exec_sql+'" queryout "'+@file_path+''+@file_name+'" -c -T -U "sa" -P "sa"';
exec master..xp_cmdshell @exec_sql