alter table t1 add column_name datatype default(dateadd(month,1,getdate()))
create view v1 as select getdate() as dates gocreate function f_getDate returns datetime as begin declare @re datetime select @re=dateadd(mm,1,dates) from v1 return @re end goselect dbo.f_getDate() godrop function f_getDate drop view v1 go go go
create view v1 as select getdate() as dates gocreate function f_getDate returns datetime as begin declare @re datetime select @re=dateadd(mm,1,dates) from v1 return @re end goselect dbo.f_getDate() godrop function f_getDate drop view v1 go
create function f_date(@date datetime) returns datetime as begin set @date=(select dateadd(mm,1,@date)) return @date endgo select dbo.f_date(getdate())
as
select getdate() as dates
gocreate function f_getDate
returns datetime
as
begin
declare @re datetime
select @re=dateadd(mm,1,dates) from v1
return @re
end
goselect dbo.f_getDate()
godrop function f_getDate
drop view v1
go
go
go
as
select getdate() as dates
gocreate function f_getDate
returns datetime
as
begin
declare @re datetime
select @re=dateadd(mm,1,dates) from v1
return @re
end
goselect dbo.f_getDate()
godrop function f_getDate
drop view v1
go
dateadd(month,1,getdate())写起来也不麻烦
returns datetime
as
begin
set @date=(select dateadd(mm,1,@date))
return @date
endgo
select dbo.f_date(getdate())