Simple way to save parameters
Sometimes there is the need to log the startup parameters of a stored procedure. Or maybe be able to send them to a service broker for asynchronous execution. One simple way to do it is using the for xml clause. Of course there is the need for some manual work (or maybe not). The code however would look like this: Now the @params variable is ready to be used / logged / sent forward.