top 1.....
WHERE (WeekOf > @weekOf and WeekOf <=getdate())....
就可以了
WHERE (WeekOf > @weekOf and WeekOf <=getdate())....
就可以了
解决方案 »
- 在页面上放了两个RadioButton,不想设置任何一个为默认选项,如何做成必选其一的效果?
- 关于数据库的设计
- 多人同时打开ASPX文件,报错!请高手支招。。
- 如何使验证控件不起作用?
- 新手请教:2005中在Web页面使用Tree添加、删除节点的问题,具体请进来看下。
- 如何将带有JPG图片的数据导出到EXCEL中啊.
- 求救!如何使用JavaScript实现Treeview控件的操作?
- 一个很简单的问题
- 能否在一个datalist(Repeater)里嵌套另外一个datalist(Repeater)?
- 小弟新做的Flash播放器,大家给看一下
- url重写的问题?希望能帮助
- ASP.NET 页面执行时间的问题
如果我输入的是08年的日期呢
FROM Week
WHERE id = (select top 1 id from week order by min(datediff(week,@week))
比如参数是2005-06-06 查询出来的结果就是20070521
如果是2009-09-09 那么结果就是2009-09-09
FROM Week
WHERE id = (select top 1 id from week order by min(ABS(DATEDIFF(day,week,@week) ))
top 1.....
WHERE (WeekOf > @weekOf and WeekOf <=getdate())....order by WeekOf desc
else
top 1.....
WHERE (WeekOf > @weekOf ) order by WeekOf asc
FROM Week
WHERE WeekOf = (select top 1 WeekOf from week order by min(ABS(DATEDIFF(day,week,2005-05-05)))
第 3 行: ')' 附近有语法错误。
FROM Week
WHERE WeekOf = (select top 1 WeekOf from week order by min(ABS(DATEDIFF(day,week,2005-05-05))))
加括号了
SELECT *
FROM Week
WHERE WeekOf = (select top 1 WeekOf from week order by min(ABS(DATEDIFF(day,week,2005-05-05))))
服务器: 消息 207,级别 16,状态 3,行 1
列名 'week' 无效。
FROM Week
WHERE WeekOf = (select top 1 WeekOf from week order by min(ABS(DATEDIFF(day,weekof,2005-05-05))))
列 'week.WeekOf' 在选择列表中无效,因为该列未包含在聚合函数中,并且没有 GROUP BY 子句。今天有点头疼,见凉
FROM Week
WHERE WeekOf = (select top 1 WeekOf from week order by min(ABS(DATEDIFF(day,weekof,2005-05-05))) group by weekof)
FROM Week
WHERE WeekOf = (select top 1 WeekOf from week group by weekof order by min(ABS(DATEDIFF(day,weekof,2005-05-05))))