摘要:
--SQL Server 2000-----Calendar Table Geovin Du 涂聚文declare @start datetime,@end datetimeset @start = '2006-01-01'set @end = '2006-05-02'declare @no_of_Days intset @no_of_days = datediff(dd,@start,@end) + 1set rowcount @no_of_daysselect identity(int,0,1) as dy into #temp from sysobject 阅读全文