1
kudos
spam Kudos Remove

Passing Parameters to a Background Procedure

published 340 days, 6 hours, 40 minutes ago posted by sasa 346 days, 1 hour, 19 minutes ago
Tuesday, August 25, 2009 1:19:45 PM GMT Wednesday, August 19, 2009 6:41:13 PM GMT

I have posted previously an example how to invoke a procedure asynchronously using service Broker activation. Several readers have inquired how to extend this mechanism to add parameters to the background launched procedure. Passing parameters to a single well know procedure is easy: the parameters are be added to the message body and the activated procedure looks them up in the received XML, passing them to the called procedure. But is significantly more complex to create a generic mechanism that can p...

category: Query | clicked: 2 | | source: rusanu.com | show counter code
tags: Parameters, Stored Procedures

No comments yet, be the first one to post comment.

To post your comment please login or signup