34,575
社区成员
发帖
与我相关
我的任务
分享
select * from GoldCardReplacementData
where 1=1 and len(ReturnDate)>0 or len(ReturnReason)>0
and convert(nvarchar(10),returndate,120)!='1900-01-01'
and convert(nvarchar(10),ReturnDate,120)>='2012-11-01'
and convert(nvarchar(10),ReturnDate,120)<='2012-11-28'
select * from GoldCardReplacementData
where 1=1 and ReturnReason is not null
and convert(nvarchar(10),returndate,120)!='1900-01-01'
and ReturnDatebetween '2012-11-01' and '2012-11-28'
select * from GoldCardReplacementData
where 1=1 and len(ReturnDate)>0 or len(ReturnReason)>0
and convert(nvarchar(10),returndate,120)!='1900-01-01'
and convert(datetime,ReturnDate,120)>='2012-11-01'
and convert(datetime,ReturnDate,120)<='2012-11-28'