title: Is there an upper limit for passing nvarchar(max) to a database?
body: <p>I'm importing CSV data into a SQL Server via an <code>nvarchar(max)</code> parameter in a stored procedure and then splitting it using a function. I can't use Bulk insert for various reasons. </p>
  
  <p>It's likely that these strings could get very large indeed. </p>
  
  <p>Is there an upper limit to what I can pass through an SP call before things get hairy? I can split the string into batches easily but I'd like to know how small to make my batches. </p>