View results of multiple query's at once

Feature requests and their debate

View results of multiple query's at once

Postby asgair » Mon Jun 17, 2013 4:08 pm

It would be nice if I can ditch MS SQL Manager, but among other things (like support for 'Explain Plan'), I'd like to see multiple result windows for multiple queries that are executed at once, like in this silly example:

SELECT baep.id, baep.billing_id, baep.is_verified, baep.is_exported, baep.verification_at, baep.exported_at
FROM dbo.billing_admin_extra_products baep
WHERE id = 1720386;

UPDATE billing_admin_extra_products
SET is_exported = 1,
exported_at = GETDATE()
WHERE id = 1720386;

SELECT baep.id, baep.billing_id, baep.is_verified, baep.is_exported, baep.verification_at, baep.exported_at
FROM dbo.billing_admin_extra_products baep
WHERE id = 1720386;

----------------------------------------------------------------------------------------------------------------
id billing_id is_verified is_exported verification_at exported_at
1720386 663457 NULL NULL NULL NULL
----------------------------------------------------------------------------------------------------------------
(1 row(s) affected)
----------------------------------------------------------------------------------------------------------------
id billing_id is_verified is_exported verification_at exported_at
1720386 663457 NULL 1 NULL 2013-06-17 17:57:55.683
asgair
 
Posts: 3
Joined: Wed May 22, 2013 7:43 am

Re: View results of multiple query's at once

Postby Serge » Tue Jun 18, 2013 8:10 am

Hello,

You may execute multiple queries in separate result tabs using CTRL+ALT+X shortcut (or context menu/main toolbar action). Just select queries you want to execute. Queries should be divided by ";" character.
Or you mean something else? If yes then could you clarify it a little bit more.

Thanks
Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb


Return to Feature Requests



Who is online

Users browsing this forum: No registered users and 2 guests