How to direct the SQL query output to a file?

• venkat_dba

  Old Hand

  Points: 326

  More actions

  October 12, 2001 at 2:07 pm

  #78115

  How to direct the SQL query output to a file

  for a query like

  select * from test1

• Steve Jones - SSC Editor

  SSC Guru

  Points: 734434

  More actions

  October 12, 2001 at 2:33 pm

  #418926

  run from command prompt:

  osql -Sserver -E -Q"select * from test1" >> file.txt

  Or run from DTS package.

  Steve Jones

  steve@dkranch.net