Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Does it make sense to add extra parameters to SP?
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
Versions des environnements
SQL Server:
SQL Server 2005
Divers
Thread ID:
01326212
Message ID:
01326264
Vues:
15
This message has been marked as a message which has helped to the initial question of the thread.
>Hi everybody,
>
>I have a stored procedure that is used to approve a person. It updates a Registration table and then inserts information into several other tables (People and few others depending on PersonType).
>
>I added PersonID as output parameter to my SP. Does it make sense to also add FirstName and LastName as output parameters?
>
>Somehow I'm unable to retrieve them from the GridView, so perhaps I can simply get them from the SP.
>
>Does it sound like a good idea?
>
>Thanks in advance.

Why not, if that will help you to get what you want.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform