search

akarzazi / SSMSPlus

SSMS Plus is a productivity extension for SQL Server Management Studio 18 /19
76 stars 22 forks source link

Open Query Editor from a toolbar button #13

Closed gaberad closed 1 year ago

gaberad commented 4 years ago

Hi, I was wondering if the following was possible/if you could implemented it:

Essentially I'm looking for a way to open the Query Editor (?, not sure of the exact name) without having to drill down into the database tables.

It's the one where you right click on a table and go 'Edit Top 200 Rows...", and that opens the Query Editor in a new tab (as opposed to the Query Designer, which opens in a popup window).

Was wondering if a 'query-less' version of that be called from the toolbar menus/toolbar button? 'query-less' in this case meaning with an empty query pane, or if that's not possible then maybe a 'select top 200...' against a default table in master/msdb.

akarzazi commented 4 years ago

You can open the query editor from the server nodes and the database node. Right click on the node -> then new query

gaberad commented 4 years ago

Oh, yeah, I know about that one, but it's not what I'm referring to.

It's the "edit top 200 rows" option, where you can edit data directly in the results grid.

It looks like it's also called the 'Query Designer', but it opens in a new tab, rather than an a pop up.

Does that make sense? I can post screenshots when I'm back home.

gaberad commented 4 years ago

This is what I mean: image

image

akarzazi commented 4 years ago

Okay, I understand. Why opening this view in a pop up is a big deal ?

gaberad commented 4 years ago

That's because the popup doesn't actually let you execute sql queries & view/edit the results, it only helps you construct the queries e.g. for views etc.

I find that in some cases it's easier to edit data directly in the results grid, so I was looking for a way to open the tabbed query designer, like from a toolbar button, without having to drill down all the way to the tables > edit top 200...

akarzazi commented 1 year ago

Sorry, not the kind of feature in the scope. https://github.com/akarzazi/SSMSPlus#project-goals