Question? How do I add a table with a field date time/default getdate() ?

[billnbell]

How do I add to TVP a default getdate() on a column?

[TimelordUK]

can you explain exactly what you want here?

[wmakeev]

can you explain exactly what you want here?

Perhaps the question was how, when inserting data into a table, to get filled columns for which getdate() is specified as the default?

[billnbell]

Sure. When setting up a new table with parameters like field type, I want to set the default programmatically.

CREATE TABLE employee ( id INTEGER, first_name VARCHAR(200), last_name VARCHAR(200), update_date DATETIME DEFAULT getdate() );

I would to be able to set the default to "getdate()"

[TimelordUK]

yes basically this is not possible with current build- i am not sure if ODBC standard allows this to be handled easily but will try and read to see if it can be done. The column would have to be bound as it may be set for some rows, where it is not set we need defult constraint

but as things are the current version does not support this