--视图:
CREATE view V_GetAdate
as
select date=convert(varchar(10),getdate(),120)+' 20:00:00'
--函数调用
CREATE Function F_GetA8()
returns datetime
As
Begin
declare @Time dateTime
select @Time=date from V_GetAdate
return @Time
END
CREATE view V_GetAdate
as
select date=convert(varchar(10),getdate(),120)+' 20:00:00'
--函数调用
CREATE Function F_GetA8()
returns datetime
As
Begin
declare @Time dateTime
select @Time=date from V_GetAdate
return @Time
END
use northwind
go
create function fun_time(@dtime datetime)
returns datetime
as
begin
return dateadd(dd, 1, @dtime)
end
go
--测试
select dtime=dbo.fun_time(getdate()), *
from orders
--清除
drop function fun_time