CODE EXAMPLE FOR CSHARP

.net: setting max size for sql parameter

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