Post reply

BCP

  • October 8, 2003 at 8:49 am

    #101707

    While bcp'ing a flat file I would like to insert the today's date on my table...with the flat file data how can use this defualt column

    Dimpal Patel


    Dimpal Patel

  • October 8, 2003 at 10:28 am

    #477593

    if you are bcp'ing with a query then add...

    getDate() as column_name as one of the selected fields.

    Otherwise you can set the default value to the column to be getDate() and then not insert anything into it

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply