What size should be defined for NTEXT, TEXT fields before running SqlCommand.Prepare method? RRS feed

  • Question

  • Hello,

    Running SqlCommand.Prepare method requires all variable length parameters to have an explicitly set non-zero Size.

    The value of these fields is unknown in advance, what size should be defined for NTEXT, TEXT fields?

    Is any possibility to not set length to NTEXT, TEXT fields?

    Thanks in advance

    • Moved by Mike Dos Zhang Thursday, August 30, 2012 8:47 AM ADO.NET problem (From:General Windows Desktop Development Issues)
    Wednesday, August 29, 2012 11:03 AM


All replies