Search This Blog

Friday 6 November 2015

VARCHAR (MAX) size in C# or what is the size of VARCHAR (MAX) in parameter declaration in C#?

When we are using the VARCHAR(MAXfor parameter or variable declaration its default size is -1
Means VARCHAR(MAX= -1

If you want to use the VARCHAR(MAX) size for parameter declaration in c#, you use -1.

Code Look Like below

cmd.Parameters.Add("@ParamName"SqlDbType.VarChar, -1).Value = "Value";


No comments:

Post a Comment