title: What is the biggest data type to use as a local variable in a stored procedure?
body: <p>I have the next issue:</p>
  
  <pre><code>--DECLARE @TEST NVARCHAR(MAX)
  --DECLARE @TEST2 NVARCHAR(MAX)
  
  DECLARE @TEST NTEXT
  DECLARE @TEST2 NTEXT
  </code></pre>
  
  <p>NVARCHAR(MAX) is to small for the amount of text in need to put when executing a stored procedure, also, TEXT, NTEXT and IMAGE data types are invalid for local variables, what can I do to sidestep this issue and store the oversized text like.</p>
  
  <p>Thanks in advance</p>