摘要:
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 阅读全文