/**//*计算今天是星期几*/
select datename(weekday,getdate())  

/**//*查询本年的数据*/
select * from  users where year(time)=year(getdate())    

/**//*查询本月的数据，time是表users中代表时间的字段*/
select * from users where month(time)=month(getdate()) and year(time)=year(getdate())

/**//*查询今天的数据，time 是表中代表时间的字段*/
select * from users where day(time)=day(getdate()) and month(time)=month(getdate()) and year(time)=year(getdate())

/**//*计算那一天是星期一*/
SELECT  DATEADD(wk,  DATEDIFF(wk,0,getdate()),  0)  

/**//*计算那一天是周末*/
select dateadd(wk,datediff(wk,0,getdate()),6)

/**//*查询本周的数据*/
select * from users where DATEPART(wk, time) = DATEPART(wk, GETDATE()) and DATEPART(yy, time) = DATEPART(yy, GETDATE())  

/**//*查询本日的记录*/
select * from users where (DATEDIFF(dd, time, GETDATE()) = 0)

/**//*查询本月的记录*/
select * from users where (DATEDIFF(mm, time, GETDATE()) = 0)

/**//*查询本年的记录*/
select * from users where (DATEDIFF(yy, time, GETDATE()) = 0)