Within the Toad editor grid, After inserting a a row with default values defined on the columns as constraints, the default values do not appear. Similar issue goes for values set by insert triggers.
It would be expected that after the insert/update, that TOAD re-read the row (by PK) and display the current values that exist for the row instead of nulls.
対策
WORKAROUND:
None
STATUS:
Waiting for a fix in a future release of Toad for SQL Server.