I was wondering - would it be possible to make autoprocs work with default constraints and not have to require those parameters?
It's not uncommon to have a DateInserted datetime not null default getdate() in a table, but autoprocs will generate inserts and upserts that require the DateInserted parameter, kind of defeating the point of a default if it has to be sent through code...
If it cannot be done automatically, maybe a syntax change to autoproc all Table insertignore DateInserted, IsActive, FooColumn ?
I was wondering - would it be possible to make autoprocs work with default constraints and not have to require those parameters?
It's not uncommon to have a
DateInserted datetime not null default getdate()in a table, but autoprocs will generate inserts and upserts that require theDateInsertedparameter, kind of defeating the point of a default if it has to be sent through code...If it cannot be done automatically, maybe a syntax change to
autoproc all Table insertignore DateInserted, IsActive, FooColumn?