Marc:
For updates and inserts you pass as arguments the value in each field of the table your updating. In the stored procedure, you recieve these values as parameters which are then used in T-SQL code.
For selects and deletes, pass in a primary key.
I have created a framework of special data classes that automatically handle all the parameter passing and procedure calling. When I create my SQL Server database, I also create an update, insert, delete and select stored procedure for each table. On the fox side, the data classes handle the rest.
Charlie
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