Hi, New to stored procedures.
I have read loads of information but there is one thing missing.
I have a VB6 app that needs to read data from SQL Server into the client form, the user modifies the data and that then needs updating back to the server.

I'm currently using standard queries to do all that and although I can use a stored procedure to get the data into the form, it means I will have to somehow use another stored procedure to get the modified data from the client back to SQL Server! I have 20+ users all accessing data from the SQL server.

Anyone got any ideas?