Can we use NEWID(), or RAND() in function?

Hi Virendradugar

Your question is :
Can we use nondeterministic functions such as GETDATE(), NEWID(), or RAND() in function?

Generally....

GETDATE() /GETUTCDATE() / CURRENT_TIMESTAMP are Non-Deterministic function. But we can use it in User Defined Function.

NEWID() and RAND() can not be used.

CREATE FUNCTION Ufn_Test() RETURNS DATETIME
BEGIN
DECLARE @A DATETIME
SELECT @A = GETDATE()
RETURN(@A)
END

SELECT dbo.Ufn_Test()

Cheers