select substring(cast(getdate() as char(7)),1,4) as 月,substring(cast(getdate() as char(7)),5,7) as 日
substring(cast(getdate() as char(7)),1,4) 我得到的是Apr.第一个问题也请大侠指点一下...
declare @starttime datetime,@endtime datetime declare @b intset @b=0 set @starttime='2000-1-1' set @endtime='2010-1-1'while(@b>=0) begin insert into test100w(ttime)values(DATEADD(day,1, @starttime)) set @starttime=DATEADD(day,1, @starttime) set @b=datediff(day,@starttime,@endtime) end
insert into test100w(ttime)values(DATEADD(day,1, @starttime)) --改一下 insert into test100w(ttime)values(@starttime) ---假如不行,再用下面動態語句 exec ('insert into test100w(ttime) values ('+ @starttime+')')
declare @b intset @b=0
set @starttime='2000-1-1'
set @endtime='2010-1-1'while(@b>=0)
begin
insert into test100w(ttime)values(DATEADD(day,1, @starttime))
set @starttime=DATEADD(day,1, @starttime)
set @b=datediff(day,@starttime,@endtime)
end
--改一下
insert into test100w(ttime)values(@starttime)
---假如不行,再用下面動態語句
exec ('insert into test100w(ttime) values ('+ @starttime+')')