hi all i have a questio nabout ssms, is there a way to see multiple resultset when we execute some query lets say i executed a selectstatement after the result is there is the result pane can i execute the other query and have the previous result set active instead of getting it wiped out. thanks in advance.
You can execute multilple select statement simultaneously SELECT 1 SELECT 2 Highlight both and execute
[quote user="atulmar"]No. If I get it right. The functionality you are asking for is not available in SSMS.[/quote] In SSMS, click New Query in the tool bar and run the queries
This facility is there for along time. (At least for the last 11+ years). As Madhivanan correctly mentioned Simply type all the queries in a new query window (or highlight them only if you have more queries) and execute. This is facility is there in SQL 2008 too.
[quote user="preethi"] This facility is there for along time. (At least for the last 11+ years). As Madhivanan correctly mentioned Simply type all the queries in a new query window (or highlight them only if you have more queries) and execute. This is facility is there in SQL 2008 too. [/quote] Many newbies dont relaise that many features are integrated with SSMS []
I guess the expectation is keeping one result alive, and executing other queries, while previous result should not go away.
[quote user="atulmar"]I guess the expectation is keeping one result alive, and executing other queries, while previous result should not go away.[/quote] I dont think that is possible until you use multiple query windows
.. or copy the previosu results to Excel. Excel and SQL Management Studio work closely where you can copy the results and the heading from Management studio to excel.
