When we are using the VARCHAR(MAX) for 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