Declare @bDate datetime,@edate datetime,@sql varchar(1000)
select @bdate='2007-06-01',@edate='2007-06-30'
set @sql='select top '+rtrim(datediff(day,@bdate,@edate)+1)+' id=identity(int,0,1) into ttt from syscolumns a,syscolumns b'
exec(@sql)
select dateadd(day,id,@bdate) from ttt
drop table ttt
select @bdate='2007-06-01',@edate='2007-06-30'
set @sql='select top '+rtrim(datediff(day,@bdate,@edate)+1)+' id=identity(int,0,1) into ttt from syscolumns a,syscolumns b'
exec(@sql)
select dateadd(day,id,@bdate) from ttt
drop table ttt
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货