Information générale
Catégorie:
Bases de données
That's what I was afraid of. I have a large table to update and was trying to make it as painless as possible. Thanks Hector
>If you function is a function in your .NET app then what Leo told you won't work. When you execute the update the command is sent to SQL Server and evaluated by SQL Server (which knows nothing about your app/function.)
>
>To use your .NET function you'll need to process each record individually in your application to get the value for each record and then submit the UPDATE with the value (rather than with the call to CreateSalt.)
>
>
>
>>Can I use my own function in a SQL update?
>>
>>Ex: UPDATE IntranetUsers SET salt = CreateSalt(5)
>>
>>When I try to run this I get 'CreateSalt' is not a recognized function name.
>>
>>Am I going about this the wrong way?
>>
>>I have a table that I need to update this field in. I need to use a function I created that generates a value and then store it in this field used by my encryption function.
>>
>>TIA
>>Brad
Précédent
Suivant
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