how to create a text file with results of SQL statement

Last Post 06 Aug 2008 01:05 PM by bparow. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
bparow
New Member
New Member

--
06 Aug 2008 10:44 AM
I have a database on SERVER1 which has a database name of PROD
This database has a TABLE called OPRLSV_T which consists of one row which has the folliwing fields: LSF_DIR, CPY_DIR, EMER_DIR and STAT_DIR
What would be the easiest way to get the results of "SELECT * FROM OPRLSV_T" into a text file automatically?
bparow
New Member
New Member

--
06 Aug 2008 01:05 PM
I am actually looking for this to be completely automated, like in a .vbs file
You are not authorized to post a reply.

Acceptable Use Policy