110,545
社区成员
发帖
与我相关
我的任务
分享
declare @s varchar(6)
set @s='201105'
declare @date smalldatetime
set @date=@s+'01'
declare @i smallint
set @i=0
while @i<DATEDIFF(day, @date, dateadd(month, 1, @date))
begin
print convert(varchar(10), dateadd(day, @i, @date), 120)
set @i=@i+1
end
declare @date datetime
declare @end datetime
set @date = DATEADD(d,-day(getdate())+1,getdate())
set @end =DATEADD(month,1,@date)
create table temp
(
[Date] datetime
)
while(@date < @end)
begin
insert into temp values(@date)
set @date=DATEADD(d,1,@date)
end
select * from temp
drop table temp
IF EXISTS(SELECT * FROM TEMPDB..SYSOBJECTS WHERE xtype='U' and [name] like '#T1_%')
BEGIN
DROP TABLE #t1
END
--CREATE TABLE #T1(WeekEndDate SMALLDATETIME)
CREATE TABLE #T1(别名 SMALLDATETIME)
DECLARE @BeginDate SMALLDATETIME
DECLARE @EndDate SMALLDATETIME
SET @BeginDate='2009-04-01'
SET @EndDate='2010-01-01'
WHILE @BeginDate<@EndDate
BEGIN
--IF(DATEPART(WEEKDAY,@BeginDate)=7 OR DATEPART(WEEKDAY,@BeginDate)=1)
IF(1=1)
INSERT INTO #T1
SELECT @BeginDate
SET @BeginDate=@BeginDate+1
END
SELECT * FROM #T1
declare @s varchar(6)
set @s='201105'
declare @date smalldatetime
set @date=@s+'01'
declare @t table(
日期 varchar(10))
declare @i smallint
set @i=0
while @i<DATEDIFF(day, @date, dateadd(month, 1, @date))
begin
insert into @t select convert(varchar(10), dateadd(day, @i, @date), 120)
set @i=@i+1
end
select 日期 from @t