从选定日期的年初到选定日期为止的合计数，怎么写？

Question

select   sum(allpile)   from   [表]   
where    DataDatetime between convert(datetime, ltrim(datepart(yy,DataDatetime))+'-01-01 00:00:00' and @currentdatetime

Answer 1

select       sum(allpile)       from       [表]       
where         DataDatetime   between   convert(datetime,   ltrim(datepart(yy,DataDatetime))+'-01-01   00:00:00'   and   @currentdatetime怎么总提示关键字 'and' 附近有语法错误。

Answer 2

--这是SQL里面的写法
declare @dt as datetime
set @dt = getdate()select sum(allpile) from tb where DataDatetime >= convert(varchar(7),@dt,120)+'-01' and datedatetime <= @dt

Answer 3

select sum(allpile)
from [表]               
where DataDatetime between 
convert(datetime,convert(char(7),@currentdatetime,120)+'-01 00:00:00' and @currentdatetime 

Answer 4

楼主是不是要这样的select   sum(allpile)   from   [表]   where   convert(varchar(4),DataDatetime,120)='"   +   T.ToString("yyyy")   +   "'   and   DataDatetime<='"   +   T.ToString("yyyy-mm-dd")   +   "',

Answer 5

declare @currentdatetime varchar(10)
set @currentdatetime=convert(varchar(10),getdate(),120)
select sum(allpile)
from [表]               
where DataDatetime between 
convert(datetime,convert(varchar(7),@currentdatetime,120)+'-01 00:00:00') and @currentdatetime