存储过程做的日历(原创)
来源:互联网 发布:淘宝衣服店铺推荐 知乎 编辑:程序博客网 时间:2024/04/27 18:29
----功能:日历
----时间:2005-4-28
----作者:Tracy.Chuang
Create Proc SP_Calendar
@Date SmallDateTime = NULL
As
Begin
Declare @Calendar Table
(Week TinyInt,
Sun Varchar(2),
Mon Varchar(2),
Tue Varchar(2),
Wed Varchar(2),
Thu Varchar(2),
Fri Varchar(2),
Sat Varchar(2))
Declare @StartDate SmallDateTime,@EndDate SmallDateTime
Set @StartDate =DateAdd(Month,DateDiff(Month,0,IsNull(@Date,GetDate())),0)
Set @EndDate =DateAdd(Month,DateDiff(Month,0,IsNull(@Date,GetDate())) + 1,0) - 1
While DateDiff(Day,@EndDate,@StartDate) <= 0
Begin
Insert Into @Calendar
Select DatePart(Week,@StartDate) As Week,
(Case (DatePart(DW,@StartDate)+@@DateFirst)%7 When 1 Then Cast(Day(@StartDate) As Varchar(2)) Else '' End) As Sun,
(Case (DatePart(DW,@StartDate)+@@DateFirst)%7 When 2 Then Cast(Day(@StartDate) As Varchar(2)) Else '' End) As Mon,
(Case (DatePart(DW,@StartDate)+@@DateFirst)%7 When 3 Then Cast(Day(@StartDate) As Varchar(2)) Else '' End) As Tue,
(Case (DatePart(DW,@StartDate)+@@DateFirst)%7 When 4 Then Cast(Day(@StartDate) As Varchar(2)) Else '' End) As Wed,
(Case (DatePart(DW,@StartDate)+@@DateFirst)%7 When 5 Then Cast(Day(@StartDate) As Varchar(2)) Else '' End) As Thu,
(Case (DatePart(DW,@StartDate)+@@DateFirst)%7 When 6 Then Cast(Day(@StartDate) As Varchar(2)) Else '' End) As Fri,
(Case (DatePart(DW,@StartDate)+@@DateFirst)%7 When 0 Then Cast(Day(@StartDate) As Varchar(2)) Else '' End) As Sat
Set @StartDate = @StartDate + 1
End
Select Max(Sun) As Sun,Max(Mon) As Mon,Max(Tue) As Tue,Max(Wed) As Wed,Max(Thu) As Thu,Max(Fri) As Fri,Max(Sat) As Sat
From @Calendar
Group By week
End
- 存储过程做的日历(原创)
- 一个返回日历的存储过程
- 非常不错的原创 oracle 存储过程
- js做的日历
- Javascript做的日历
- ListView做的日历
- 做数据表比较的存储过程
- 自己学存储过程做的笔记
- 做一个串行执行的存储过程
- 原创:oracle 存储过程(十三)
- ASP调用SqlServer存储过程的经典示例(原创)
- ASPNET:DataGrid+存储过程的分页编辑代码[原创]
- [原创]aspnetpager 分页存储过程的实现 全代码
- 做真正的自己(原创)
- 大学生应该做的(原创)
- javascript做的日历控件
- 做一个简单的日历
- asp.net千奇百怪的日历【月儿原创】
- 腾讯七宗罪(转载)
- [原创]用MASM32编程获取windows类型
- mon21,mon22无法显示的问题试解决
- chenyun'S blog
- 一个时钟类的设计
- 存储过程做的日历(原创)
- 转载:tangtang搜论文的方法
- 在此博君一笑,祝君五一快乐!
- 是偶然,也是必然
- 华容高中
- Jbuilder+mobileset+nokia配置
- 反向代理的方式让apache支持asp
- J2ME的类
- Access数据库密码生成器