how to write query output into a text file?

• Santosh-738757

  SSC Enthusiast

  Points: 125

  More actions

  July 17, 2009 at 12:37 am

  #139999

  Hi,

  I have a query. I want to redirect the output of a query to text file.

  I want to execute this query analyzer.

  How to do this? Please reply me.

  Thank you,

  Santosh

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  July 17, 2009 at 1:34 am

  #1026042

  Select from the menu: Query, results to..., File.

  Ctrl+Shift+F is the shortcut for it.

  I think you picked the wrong post type anyway, this is not a poll.

  Regards

  Gianluca

  -- Gianluca Sartori

• VaibhavChoubey@SQL

  Ten Centuries

  Points: 1033

  More actions

  July 17, 2009 at 6:08 am

  #1026118

  You can also use bcp queryout to solve your purpose