tsql - NullDisplayText in markup vs ISNULL(field, 0) in SQL? -


Which approach is better to use:

  • Boundfield NullDisplayText is not set in the zero-case SQL query, i.e. SELECT ISNULL (amount, 0) to the table

or

< Ul>
  • Bound Field. The empty display text is set to , eg "0.00%" in the SLL query the case of zero is not envisaged; i.e. SELECT amount from the table

    • What do you think?

    "post-text" itemprop = "text">

    Can you do the best of both?

    • ISNULL works in only one case
    • Formatting / UI must have reason
    • Other clients using "zodiac" tap
    • 0 means zero, zero meaning is unknown / nothing: 2 different states

    Comments

    Post a Comment