SQL Server question

[Argo]

Is there a query tool for MS SQL Server like SQLPlus or DB2? Something that would allow me to connect to the database and issue queries?

 

[UCJefe]

Yes, it's called Query Analyzer and is installed with the 'client tools' portion of the SQL Server install. You can also issue queries from within Enterprise Manager which again is shipped with the SQL Server install.

 

[Gunslinger08]

Originally posted by: Argo
Is there a query tool for MS SQL Server like SQLPlus or DB2? Something that would allow me to connect to the database and issue queries?

UCJefe is absolutely correct. Query Analyzer is about 10 times better than issuing queries in Enterprise Manager though. And EM is still about 200 times better than SQLPlus.

 

[Mucman]

I've been playing with SQL Express and using SQL Express Manager to query it. I like Query Analyzer a bit more, but XM seems to do the job.

 

[Argo]

Originally posted by: joshsquall

Originally posted by: Argo
Is there a query tool for MS SQL Server like SQLPlus or DB2? Something that would allow me to connect to the database and issue queries?

And EM is still about 200 times better than SQLPlus.

Those are different things though. EM is more on the line of Oracle Enterprise Console, the only plus being that for some reason Oracle implemented theirs as a web app, therefore requiring heavy app server, wherein EM is pretty lightweight.

Regardless, thanks for the answers, both of you.