Toad World® Forums

INSERT INTO (... Select ...) defaults for BIT fields is '' but should be 0


When you use the auto builder for INSERT INTO (… SELECT …) the default values that Toad puts as placeholders for BIT data type fields is ‘’ but in my opinion they should be the default defined in the DEFAULT constraint, or failing that, just something valid, like 0 or 1.



I am in full agreement! This is something silly that I keep having to override.