方案一:declare @count intset @count = 0declare @begin datetime, @end datetimeset @begin = '2011-9-1'set @end = '2011-9-30'while @count <= DATEDIFF(day,@begin,@end )begininsert into b(工号,姓名,日期)select 工号,姓名,DATEADD(DAY,@count,@begin) from a
set @count = @count + 1end方案二:declare @begin datetime, @end datetimes...
|