how to save result in notepad via sql query

• nikhil.desai1

  SSCommitted

  Points: 1948

  More actions

  July 28, 2010 at 3:30 am

  #142124

  hi,

  When i fire

  Select * from <tablename>

  the result should should get save in txt file(notepad). C:\test.txt

  the tablename can be any table name .

  Plz give me some solution.

  Thank u in advance,

  Regards,

  Nikhil P Desai

• Praveen Goud Kotha

  Ten Centuries

  Points: 1141

  More actions

  July 28, 2010 at 3:36 am

  #1199134

  plz refer...bcp(BULK COPY) commands..we will get more info(i.e. not only to txt files, even you can copy the data into different types of files..)

  [font="Comic Sans MS"]Praveen Goud[/font]