Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>>I'm being stupid. I can use a parameterized procedure... just pass it the actual data.... So I don't have to create a new procedure each time. I may not be an expert with TSQL now. (I've not been doing it very long.) But I will be ...
>
>except that according to the documentation -- SQLEXEC does not return the value return by sQl statement. It returns -1 for connect error , 0 if it is still executing, and 1 if successful. I'm still writing a procedure that returns @@rowcount, just in case the documentations is wrong (as sometimes happens with Microsoft.._
Gar,
SQLEXEC can also return the cursor, so the very last statement of your stored proc will be SELECT count(*) ..... or like
Oleg
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