SSMS - An Option to show the SQL Statement in the "Edit Top n Rows" permanently
In "Ediit Top n Rows" It would be great to have an option like "SHOW SQL Statement in 'Edit Top n Rows' under Tools Options - to show the sql script permanently like in "SELECT n Rows"
At the moment you have to di it on a rather difficult way:
Although I have been working with the SSMS (SQL Server Management Studio) for years - and there with the right mouse button - I did not realize that you can edit the underlying SQL script and change it, in principle just like the "SELECT TOP n" The difference is that the "SELECT TOP n" automatically shows the script at the top and the result at the bottom. When "EDIT TOP n" "only" the result is displayed and I have not found a way to change the outfit as in the "SELECT TOP n", so that the result appears equally visually divided.
But here too the right mouse button helps. In the table displayed use right mouse button "Pane" - that opens another submenu with
"Diagram" - The underlying table as image
"Criteria" - The columns of the checkbox option (handy, tick changes the SQL statement)
"SQL" - The associated SQL script
"Results" - hide / show the editable table
After changing the SQL statement, you have to re-execute the right mouse button - Execute SQL - because the "Execute" button (from the Edit menu) at the top of the menu bar remains greyed out.
In this way you also can edit the SQL statement with "EDIT TOP n".