How can we help you today? How can we help you today?

Computed columns in table variables underlined in green

When I include a computed column in a table variable, SQL Prompt 9 and later underlines it in a green squiggly line with the tooltip [NOT] NULL option is not specified in CREATE/DECLARE TABLE statement.

Computed columns do not use the [NOT] NULL construct....

Can this be corrected?
DBAJohnny
0

Comments

5 comments

Sort by
  • FabiolaB
    Hi @DBAJohnny,

    Thank you for reporting this.
    I've created a ticket for this issue (ref SP-6761).

    Regards,
    Fabiola
    FabiolaB
    0
  • DBAJohnny
    Cool! Thanks!
    DBAJohnny
    0
  • torsten.strauss
    If I remember correctly (no laptop currently available) you can determine Null/ Not Null for a computed column if you add Persist which makes sense in some cases.
    So if you fix the rule please consider to detect Null/ Not Null for persist computed columns but not for a non Persisted column.

    I hope that makes sense...

    Torsten
    torsten.strauss
    0
  • FredericoJ
    Hi @DBAJohnny,

    We've fixed this issue in our latest version of SQL Prompt 9.0.8.3873 (installer here).

    You can find more information about this release in this forum post.

    Kind regards,

    Frederico
    FredericoJ
    0
  • DBAJohnny
    Ok, I've installed the update. Thanks for the heads up!
    DBAJohnny
    0

Add comment

Please sign in to leave a comment.