创建一个存储过程设定时间范围参数create proc sp_time(@begintime smalldatetime,@endtime smalldatetime,@tmptime smalldatetime=@begintime)asbegindeclare@T table(t smalldatetime)while @tmptime<=@endtimebegininsert @T (t) values (@tmptime)set @tmptime=dateadd(mm,1,@tmptime)endselect left(convert(varchar,t,1...
|