create function GetTable(@time datetime) returns @t table(sno varchar(20),sname varchar(20),times datetime) as begin insert into @t values('1','csdn',@time) return end select * from dbo.GetTable(getdate())
create function GetTable(@time datetime) returns @t table(sno varchar(20),sname varchar(20),times datetime) as begin insert into @t(sno,sname,times) select id,code,@time from area return end select * from dbo.GetTable('2011-1-2')
create function GetTable(@time datetime)
returns @t table(sno varchar(20),sname varchar(20),times datetime)
as
begin
insert into @t values('1','csdn',@time)
return
end
select * from dbo.GetTable(getdate())
create function GetTable(@time datetime)
returns @t table(sno varchar(20),sname varchar(20),times datetime)
as
begin
insert into @t(sno,sname,times) select id,code,@time from area
return
end
select * from dbo.GetTable('2011-1-2')