in reply to Returning two records with SELECT statement and then printing to file

Win:

IIRC, you can do it without perl with:

isql -S ssss -d dddd -U uuuu -P pppp -i yourSqlScript.sql -o LPT1:

[download]
Where ssss is the server name, dddd is the database name, uuuu is your user name, pppp is your password. Put your SQL statements in the yourSqlScript.sql file, and I'm assuming your printer is set up to be the local printer for your DOS shell.

...roboticus

  • Comment on Re: Returning two records with SELECT statement and then printing to file
  • Download Code

In Section Seekers of Perl Wisdom