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

Click here to load this message in the networking platform