What size do you use for varchar(MAX) in your parameter declaration?

In this case you use -1.


For those of us who did not see -1 by Michal Chaniewski, the complete line of code:

cmd.Parameters.Add("@blah",SqlDbType.VarChar,-1).Value = "some large text";