One of our contractors asked us to provide him with some MS SQL functions to update requests using them.

I know there's an API and is easier and more reliable. but unfortunately the contractor is not familiar and is not going to get familiar with using the API.

I'm already running SQL Server Profiler on the server and keeping track of update queries executed after updating a request. but there are lots of queries executed. Is there anyone else who had worked on this and can help me through?