Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Bug or Behaviour ?
Message
De
28/07/2003 12:26:08
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Divers
Thread ID:
00814082
Message ID:
00814169
Vues:
21
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform