How to use Getdate() in sql server function_PHP tutorial

create view v_getdate
as
select getdate() [output]
go
-------------------------- -------------------------------------
create function f_getdate()
returns datetime
as
begin
declare @n datetime
select @n = output from v_getdate
return(@n)
end
go
------ -------------------------------------------------- -------
Call: select dbo.f_getdate()
============================== =========================================
-----Below It is parsed--
should be used inside function and is not allowed to be used.
Functions can be deterministic or indeterminate. Functions are deterministic if they always return the same result whenever they are called with a specific set of input values. Functions are nondeterministic if the results returned are different each time they are called, even with the same specific set of input values.
Uncertain functions can have side effects. A side effect is to change some global state of the database, like updating a database table or some external resource like a file or network, etc. (for example, modifying a file or sending an email message).
Building non-deterministic functions into the body of a user-defined function is not allowed; these non-deterministic functions are as follows:
@@CONNECTIONS @@TOTAL_ERRORS
@@CPU_BUSY @@TOTAL_READ
@@IDLE @@TOTAL_WRITE
@@IO_BUSY GETDATE
@@MAX_CONNECTIONS GETUTCDATE
@@PACK_RECEIVED NEWID
@@PACK_SENT RAND
@@PACKET_ERRORS TEXTPTR
@@TIMETICKS
Although in the user-defined function body Indeterminate functions are not allowed; these user-defined functions can still produce side effects when calling extended stored procedures.
Since extended stored procedures can have side effects on the database, calling functions of extended stored procedures is undefined. When a user-defined function calls an extended stored procedure that has side effects on the database, do not expect the result set to be consistent or to execute the function.

http://www.bkjia.com/PHPjc/630947.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/630947.htmlTechArticlecreate view v_getdate as select getdate() [output] go ------------ -------------------------------------------------- - create function f_getdate() returns datetime as begin declare @...