62,046
社区成员
发帖
与我相关
我的任务
分享
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())