Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Does it make sense to add extra parameters to SP?
Message
 
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
Titre:
Does it make sense to add extra parameters to SP?
Versions des environnements
SQL Server:
SQL Server 2005
Divers
Thread ID:
01326212
Message ID:
01326212
Vues:
90
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.
If it's not broken, fix it until it is.


My Blog
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform