Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
Can we use NEWID(), or RAND() in function?
on 9/10/2009 | Category:
Sql Server Interview questions
| Views: 5483
Many Interviews |
< Previous :
Can we use "Print" statement in function ...
Next > :
What is Difference between Callbacks and Postback ...
Comments or Responses
Your question is :
Can we use nondeterministic functions such as GETDATE(), NEWID(), or RAND() in function?
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
DECLARE @A DATETIME
SELECT @A = GETDATE()
Login to post response
More Interview Questions by Virendradugar
What is Difference between Callbacks and Postback in ASP.NET?
What Are The Difference Between AutoEventWireup="true" and A ...
Can two different programming languages be mixed in a single ASMX file ...
How many .NET languages can a single .NET DLL contain?
Can we use Truncate command on a table which is referenced by FOREIGN ...
How many classes can a single .NET DLL contain?
What command do we use to rename a db, a table and a column?
What is a table called, if it has no Cluster Index?
Latest Interview Questions
________is one of the new feature added in C# 4.0 ?
How can we access COM object in C#4.0?
________ is new type introduced in C#4.0?
Which is the base class for TypedDataset
Which of the following class does not belong to Collection namespace ?
Which property of textbox cannot be change at run time?
What is the name of base class for .NET
Is it Possible to create more than one machine config file.