视图里不需要过虑日期,日期放在查询视图的where条件里select * from 视图名 where 日期=@date --这里的@date就是参数
select * from tb where dt = '2009-03-02' select * from tb where convert(varchar(10),dt,120) = '2009-03-02'select * from my_view where dt = '2009-03-02' select * from my_view where convert(varchar(10),dt,120) = '2009-03-02'
declare @dt as datetime set @dt = '2009-03-01'select * from tb where dt = @dt select * from tb where convert(varchar(10),dt,120) = @dt select * from my_view where dt = @dt select * from my_view where convert(varchar(10),dt,120) = @dt
select * from tb where convert(varchar(10),dt,120) = '2009-03-02'select * from my_view where dt = '2009-03-02'
select * from my_view where convert(varchar(10),dt,120) = '2009-03-02'
set @dt = '2009-03-01'select * from tb where dt = @dt
select * from tb where convert(varchar(10),dt,120) = @dt select * from my_view where dt = @dt
select * from my_view where convert(varchar(10),dt,120) = @dt