Computed columns in table variables underlined in green

DBAJohnny

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?

FabiolaB

Hi @DBAJohnny,

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

Regards,
Fabiola

DBAJohnny

Cool! Thanks!

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

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

DBAJohnny

Ok, I've installed the update. Thanks for the heads up!