title: Which performance is best (Table type or XML) to Pass as Parameter in to SQL function
body: <p>I need to pass data into a sql function which resides on another db. Data is more than 10000 at a time. So what is the best practice/performance for passing data into sql function.</p>
  
  <ol>
  <li>BY XML</li>
  <li>By Table Type.</li>
  </ol>
  
  <p>Please advise me as it's urgent.I need best performance. If possible please give me benchmark or example also.</p>
  
  <p>Thanks in advance.</p>