I use Toad to generate a base insert statement, but there are problems with this method. I generate them by right clicking the table, selecting Generate SQL to Editor.
The first problem is that computed columns are included in the insert statement, which shouldn’t be.
Second, bit datatype defaults to a text string of the field name. This should default to 1 or 0.
Is there a way to customize the functionality of this? For example, one of the primary reasons I use it is to insert a “unknown” value in a table for data warehouse purposes. Mine would default to specific values appropriate for an unknown value such as ‘Unknown’ for longer character fields, getdate() for date fields (or perhaps ‘1/1/1900’), etc.
Is there any way to set that up?