Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problem with UDF parameters
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Divers
Thread ID:
01020343
Message ID:
01020656
Vues:
22
Yes, but there is an overhead in creating a temp table because it has to physically exist in tempdb whereas in this case there are unlikely to be many rows in the lookup table variable so it should only exist in memory.

I have had bad experiences with table variables in the past. It's a pity the function in SQL didn't work, but at least I learnt something from this.

Simon
SJC Systems Limited
WorldSpreads Limited (www.worldspreads.com)
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform