Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Bug or Behaviour ?
Message
From
28/07/2003 12:26:08
 
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
00814082
Message ID:
00814169
Views:
20
Hi Sergey,

is, i use TSQL variables.

Another trick is:
CREATE TABLE _Today ( _getdate AS getdate() , _dummy bit NOT NULL)
INSERT _Today VALUES (0)
on UDF
DECLARE @Today DATETIME
SELECT @Today=_getdate FROM _Today
but for function like RETURN TABLE, i need SQL eval GETDATE() only one time,
and i'm not sure it is true:
SELECT ...complexmultijoin WHERE (SELECT @Today=_getdate FROM _Today)>myDate
Then, why UDF not support GETDATE(), if i can workaroud it easy ???

Master of Master question:

EXIST A FORUM WHERE MICROSOFT COMMENT CHOICES DONE ON MS DEVELOPERS APPLICATIONS ?

Fabio
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform