--定义一个视图,从视图中获取当前月分 create view vwMonth as select NowMonth=Month(getdate())go create function fnTest(@month int) returns float as begin declare @NowMonth int select @NowMonth=NowMonth from vwMonth return 1.0*@NowMonth endgo declare @n int select dbo.fnTest(@n)go drop view vwMonth drop function fnTest
CREATE FUNCTION fn_myfun(@month int) RETURNS float AS BEGIN return isnull(@month,Month(getDate())) END
CREATE FUNCTION fn_myfun(@month int) RETURNS float AS BEGIN ...... END--调用时传过去就行了. fn_myfun(month(getdate()))
CREATE FUNCTION fn_myfun()
RETURNS float
AS
BEGIN
declare@month int = Month(GetDate())
...
END declare
RETURNS float
AS
BEGIN
declare @month int
select @month = Month(GetDate())
END
@@PACK_SENT
GETDATE()
@@CPU_BUSY
@@PACKET_ERRORS
GetUTCDate()
@@IDLE
@@TIMETICKS
NEWID()
@@IO_BUSY
@@TOTAL_ERRORS
RAND()
@@MAX_CONNECTIONS
@@TOTAL_READ
TEXTPTR()
@@PACK_RECEIVED
@@TOTAL_WRITE
create view vwMonth
as select NowMonth=Month(getdate())go
create function fnTest(@month int)
returns float as
begin
declare @NowMonth int
select @NowMonth=NowMonth from vwMonth
return 1.0*@NowMonth
endgo
declare @n int
select dbo.fnTest(@n)go
drop view vwMonth
drop function fnTest
RETURNS float
AS
BEGIN return isnull(@month,Month(getDate()))
END
RETURNS float
AS
BEGIN
......
END--调用时传过去就行了.
fn_myfun(month(getdate()))
fn_myfun(month(getdate()))真的可以吗?我的fn_myfun()是用在视图里的(每行一次)
set @month = month(getdate())
fn_myfun(@month) 这样肯定行.