Passing bulk data through xml parameter or table parameter in stored procedure, which one is better

• anoop.singh 79633

  Grasshopper

  Points: 15

  More actions

  December 12, 2013 at 4:25 am

  #98951

  Hi,

  I am passing bulk data to stored procedure through xml string for insert/update operation.

  Can any one tell passing bulk data through xml or through table parameter to stored procedure, which one better, with explanation.

  Thanks,

  Anoop Singh

• Arthur Olcot

  SSCertifiable

  Points: 6639

  More actions

  December 12, 2013 at 4:56 am

  #1672894

  If you are able to influence the development from the off, then I would go with TVP as shreding XML is very expensive.

  There are lots of resources on this very topic:

  http://www.dbdelta.com/maximizing-performance-with-table-valued-parameters/

  http://www.sommarskog.se/arrays-in-sql.html