I am working on sql server. i am using bcp utility,a utility similar to sql*loader in oracle. I will be uploading data into a table using a flat file, but the flat file will not have the date value for one of the date columns.
What i want is while the loading data i want the date column to have default of system date inserted into that column.
Please help me on this
thanks in advance.
01-29-2002, 08:55 AM
You can specify default value for each column inside the database.
ALTER TABLE my_table MODIFY my_date_column DEFAULT SYSDATE;
01-29-2002, 09:38 AM
Actuall i want to do this in SQL SERVER.SQL SERVER DOES NOT SUPPORT SYSDATE FUNCTION.