--建立测试环境
Create Table TEST(ID Int,TESTDate Varchar(10))
Insert TEST Values(1,'2005-11-01')
Insert TEST Values(3,'2005-11-05')
Insert TEST Values(5,'2005-11-11')
Insert TEST Values(7,'2005-11-15')
Insert TEST Values(9,'2005-11-21')
--测试
Select * from TEST
Where DateDiff(wk,TESTDate,GetDate())=1
--删除测试环境
Drop Table TEST
--结果
/*
ID TESTDate
7 2005-11-15
*/