XML Paramter VS Table Valued Parameters

• Azzu

  Ten Centuries

  Points: 1363

  More actions

  April 1, 2010 at 10:27 am

  #213352

  Hi

  I have a small question regarding the parameters in a Stored Procedure. Is there any considerable advantage in using Table Valued Parameters over XML parameters while passing to a stored procedure.

  My only concern is relating to the performance. Which of the two gives more performance?

  Thanks in advance.

  Azeem.

• Paul White

  SSC Guru

  Points: 150467

  More actions

  April 1, 2010 at 10:33 am

  #1144222

  There is a very full analysis here:

  http://www.sommarskog.se/share_data.html

  Not just XML and TVPs either...:-)

  Paul White
  SQLPerformance.com
  SQLkiwi blog
  @SQL_Kiwi