mercredi 15 juillet 2015

How to show results of SQL SELECT in pages?

  • Client: Ubuntu 14.04LTS and isql.
  • DB Server on another machine: MS SQL 2005 (I can do nothing to update this, please don't ask.)
  • Queries run fine, I just want to show one page of SELECT results at a time.
  • Obviously I don't do a lot of SQL. I normally set up my SQL statements in Perl, set it and forget it. But for now I need to browse some records via isql.

I've been Googling for an answer, and searched Stack Exchange, and looked at the man page for isql, which is short on answers. I know how to send output to HTML pages via isql, but I don't want to do that. I want to show only N records at a time when I execute a one-time select, just for browsing records. Is there even a way to do this? Is there an SQL SET command for this?

Thank you.

Aucun commentaire:

Enregistrer un commentaire