Using XML as a input parameter
-I wouldn’t use a XML as a input parameter to update a table; mainly to avoid the XML reader operation.
-This approach will lock the updating table for extensive period which is not acceptable
Watch out if you are attempting to update a large table using a table value parameter, the chances are that you will lock the updating table for a lengthy period of time causing longer transaction response times on your application which won’t be acceptable.
Some details on table –value parameters