Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Does it make sense to add extra parameters to SP?
Message
 
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01326212
Message ID:
01326223
Views:
14
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
Previous
Reply
Map
View

Click here to load this message in the networking platform