找出两个日期之间的所有记录的SQL如何写SQL code: selct * from 表名 where 时间字段 between 开始时间 and 结束时间
SQL code: select * from 表名 where 时间字段 between 开始时间 and 结束时间
where time>=开始时间 and time <=结束时间 楼主使用between...and...就可以了，
declare @sdate datetime declare @edate datetime set @sdate = '2008-10-15 00:00:000' set @edate = '2009-02-10 00:00:000'
select dateadd(dd,num,@sdate) from (select isnull((select count(1) from sysobjects where id <t.id),0) as num from sysobjects t) a where dateadd(dd,num,@sdate) <=@edate StrSQL = StrSQL&" and (datevalue(buy_date) between buy_date1 and buy_date2)" 这语句错在了哪里 datevalue?
