Query results to a separate window

Question

Query results to a separate window

Viewing 4 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Mahesh Bote SSCrazy Eights Points: 9107 More actions · Answer 1

[font="Verdana"]I think you are looking for a tool like RapidSQL. You will have separate window TAB for result and for queries. However it is tremendously slow as compared to MS SQL Server's Query analyzer. Anyways, just check out on net for more details on it.

Mahesh[/font]

MH-09-AM-8694

RaiderX Say Hey Kid Points: 678 More actions · Answer 2

Thanks for the reply. I've always used Query Analyzer because that came with SQL Server and I never bothered to look at anything else. Are there other tools like QA that are really good and worth taking a look at?

David

Ron McCullough SSC Guru Points: 63877 More actions · Answer 3

Have you considered out putting the Query results to a file, and then opening that file with a text editor such as Codewright, on your 2nd monitor? True a small bit of extra work, but with a distinct advantage in being abe to compare multiple results as you edit your T-SQL.

CodeWright is a Windows Programmers Editing System for software developers originally marketed by Premia Corp. (Beaverton, Oregon) and developed by Premia co-founders Eric Johnson and Don Kinzer, initially released in 1991. Premia was acquired in April 2000 by Starbase Corp. which was itself acquired in January 2003 by Borland.

Latest link I could find for Codewright

http://www.borland.com/us/company/news/press_releases/2003/04_15_03_codewright_75.html

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

RaiderX Say Hey Kid Points: 678 More actions · Answer 4

No, I didn't think of that, but good suggestion. I'll take a look at Codewright.

What I might also do is have two instances of Query Analyzer open, one in each monitor. In the second monitor however, I'll have the query window really small and the font really small. In the first monitor, I'll have the query larger and easier to read and modify. I'll just cut and paste between the two instances.

Do you use Query Analyzer and if not, any recommendations? I'm always intersted in any tool that will make me more productive.

Thanks,

David