I have to create a stored procedure where I pass in 4 variables, each with different lengths, and I need to check to see if there is an apostrophe that I replace it with a double quote. I then need to insert the record into the table. If everything goes OK, I'd like to pass back a variable to my VB program indicating that the INSERT worked fine.
Could someone throw together the snippet of code on what would be required to put this all together and please a short comment on each step of what is going on.
Fairly new to creating stored procedures. Have always using the INSERT, UPDATE and DELETE in my VB code using ADO and am trying to convert everything to stored procedures.
Thanks in advance.