Mike Yearwood
Toronto, Ontario, Canada
Information générale
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Network:
Windows 2008 Server
>>Sir, What is the reason of using varchar ?
>
>Copied from the original sample code posted.
>
>Don't use it myself,
>the only virtue I know of is that it trims values automatically - simplifies chain concatenation
>same storage length though
>
>In this particular case, C(254) should be good enough.
>
>I would even try a M as you don't need any index on this column, and your source data is CSV.
>
>As the file is huge, saving space on disk might also save execution time - to be tested though
append from FOR is very slow. Each record is added temporarily to the cursor and then discarded if it fails the for condition test. :)
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement