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

Question

Hi,

I normally set my column size when creating a parameter in ADO.NET

But what size do I use if the column is VARCHAR(MAX)?

cmd.Parameters.Add("@blah", SqlDbType.VarChar, ?????).Value = blah;

Answer 1

In this case you use -1.

Answer 2

Can I omit it like this to get the same result?

cmd.Parameters.Add("@blah", SqlDbType.VarChar).Value = blah;

Answer 3

Yes you can omit the size.