建立一对相对动态视图,主要与当前时间有关.....分数不够再加.多请高手的指点

[suziniren]

表T_AA 中有一字段是varchar的...值为 20050922001,20050922002,20050922003,20050923001,20050922002,20050922003

我现在想建立一个视图查询近十五天的记录我要怎么写啊???视图中只显示近十五天的记录

谢各位大侠指点...谢谢了

[子陌红尘]

create view v1 as
select
*
from
T_AA
where
datediff(dd,cast(字段名 as datetime),getdate())<15

[子陌红尘]

create table T_AA(col varchar(20))
insert into T_AA select '20050901001'
insert into T_AA select '20050906001'
insert into T_AA select '20050907001'
insert into T_AA select '20050908001'
insert into T_AA select '20050909001'
insert into T_AA select '20050912001'
insert into T_AA select '20050915001'
insert into T_AA select '20050901001'
insert into T_AA select '20050922001'
insert into T_AA select '20050922002'
insert into T_AA select '20050922003'
insert into T_AA select '20050923001'
insert into T_AA select '20050922002'
insert into T_AA select '20050922003'
go


create view v1 as
select
*
from
T_AA
where
datediff(dd,cast(left(col,8) as datetime),getdate())<15
go


select * from v1
/*
col
-----------
20050908001
20050909001
20050912001
20050915001
20050922001
20050922002
20050922003
20050923001
20050922002
20050922003
*/

[suziniren]

libin_ftsafe(子陌红尘)十分感谢你的帮助,谢谢!