BCP

• Dimpal

  SSC Enthusiast

  Points: 173

  More actions

  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

• dan_jf

  SSC-Addicted

  Points: 496

  More actions

  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