摘要: IF OBJECT_ID('tempdb..#t') IS NOT NULL DROP TABLE #t;create table #t(id int identity,Dt varchar(10));declare @starttime datetime,@endtime datetimeset @starttime = '===start==='set @endtime ='===end==='insert #tselect convert(varchar(10),dateadd(day,number,@starttime),112) dtf 阅读全文
posted @ 2013-05-14 11:23 一千零一夜 阅读(204) 评论(0) 推荐(0) 编辑