While using SQL Server Management Studio (2008), is it possible to open a table in Edit mode through keyboard shortcut or even some special keyword I type while in "New Query" window?
Go to Tools > Options. In the tree on the left, select SQL Server Object Explorer. Set the option "Value for Edit Top Rows command" to 0. It'll now allow you to view and edit the entire table from the context menu.
In the Object Explorer, select the database you attached and expand its contents. From the Tables category, select the table you want to view. Right-click on the table name and select Edit Top 200 Rows from the contextual menu. The table contents (the first 200 rows) is opened in a new tab window, on the right side.
CTRL+L. Delete current code line and copy it to clipboard. SQL Editor.
No this can't be done.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With