SQL表值函数(上月添加1-28)

 ALTER function [dbo].[fn_getdate3]
(
@cc varchar(15)
)
RETURNS
@Table_Var TABLE
(
LastTime datetime
)
as
begin
Declare @rand float
Declare @num Int
set @num=6
while (@num>5 and @num<15)
begin
select @rand=re from v_RAND
insert into @Table_Var
select dateadd(day,@rand*28,[Date]) from A01 Where ID=@num
set @num=@num+1
end
return
END
上一篇:Bower是什么?


下一篇:JAVA之旅(三十二)——JAVA网络请求,IP地址,TCP/UDP通讯协议概述,Socket,UDP传输,多线程UDP聊天应用