A point to be noted while using queries in SQLCLI
Sometime time back I faced a problem when I was using the queries in SQLCLI. Every time I executed a query the result set was not displayed, rather an error message 'more' is not recognized as an internal or external command, operable program or batch file was displayed. I thought that it was due to some problem with the SQLCLI console but it was due to some other reason. The reason was the operating system's paging settings. There is a command called MORE which helps in displaying one screen of output at a time in command line consoles.
If your system cannot call the MORE command then probably you will not be able to get the results for the query even if your query is correct.
Click the below links to learn more about the MORE command
Windows Platform
Unix and Linux Platform
Hope this will help you save time when you come across a similar situation. SQLCLI error.
