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:
01326223
Vues:
16
Ok, I guess I'm going to repeat Derek's path, since nobody replies anyway...

I added extra parameters to my SP.

>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform