OT: Database scroll window.

[TomChapman]

I've worked for years with MySQL. MySQL has an included program,
mysql.exe, that is a giant scroll window where you can type SQL
statements and see the results scroll by within the window. I have grown
use to having this feature in my tool set.

Now for the first time I am working with a project that uses Microsoft
SQL Server. Is there a program that does the same thing for MS SQL
Server? I'd prefer a free or cheap program that I can download.

[Frank Thomason]

Post by TomChapman
I've worked for years with MySQL. MySQL has an included program,
mysql.exe, that is a giant scroll window where you can type SQL
statements and see the results scroll by within the window. I have grown
use to having this feature in my tool set.
Now for the first time I am working with a project that uses Microsoft
SQL Server. Is there a program that does the same thing for MS SQL
Server? I'd prefer a free or cheap program that I can download.

SQL Server comes with a console (command line) tool called sqlcmd that
is similar to the mysql.exe utility. Type sqlcmd -? to get a list of
command options.

[Tony Toews]

On Tue, 08 Nov 2011 16:48:38 -0600, TomChapman

Post by TomChapman
I've worked for years with MySQL. MySQL has an included program,
mysql.exe, that is a giant scroll window where you can type SQL
statements and see the results scroll by within the window. I have grown
use to having this feature in my tool set.
Now for the first time I am working with a project that uses Microsoft
SQL Server. Is there a program that does the same thing for MS SQL
Server? I'd prefer a free or cheap program that I can download.

SQL Server Management Studio Express should have almost everything you
need. https://www.microsoft.com/download/en/details.aspx?id=7593
There's a different version for SQL Server 2005.

Now it won't, as far as I know, scroll the results. However you can
see the first 1000 records of your query or more if desired.

Tony