On Friday, 22 February 2013 01:38:34 UTC, JAW  wrote:   
   > My Vparameterdefinition just needed to be increased just needed to be   
   increased and it worked.   
      
   I like to construct SQL strings with --X   
   marking the end, and check that it's still there at   
   the point of execution - and to use @{name_of_a_token}   
   for expressionss to insert (by REPLACE) in a single string.   
   This seems to work well on nvarchar(max) - I think -   
   where some constructions (I'm not sure which ones)   
   seem to impose a 4000 or 8000 character limit.   
      
   But, putting BEGIN and END around a block is another   
   way to get the benefit of validation.  Some SQL   
   statements, you really don't want to cut short -   
   like, DELETE with no parameters erases every file   
   on the server.  (It doesn't.)   
   you   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)