Understanding Hostname and ThreadId in SQL Stored Procedures

Passing DataTable from C# to SQL Server Stored Procedure Using XML